Based on query condition. it wil update all the fields which are mentioned in the query.
ex: update employee set firstname= @firstname,lastname=@lastname where employee_id =@employee_id.
Related: LOOP AT with WHERE Clause
so in the above case nothing will be happen if you used where clause or not.
if you have many statements in the query u need to use the where clause.
Will update all the records in the table