The WHERE clause determines which rows will be updated. It is an optional element of the UPDATE statement. If the WHERE clause is omitted, all rows in the table will be updated. The WHERE clause is so important that you should not forget. Sometimes, you may want to change just one row of the table; if you forget the WHERE clause, the UPDATE statement will update all the rows, which is not what you expected.