In this case, there is only one row that satisfies the condition in the WHERE clause. If there are multiple rows that satisfy the condition, all of them will be modified. If no WHERE clause is specified, all rows will be modified.

Update Multiple Columns

It is also possible to UPDATE multiple columns at the same time. The syntax in this case would look like the following: