SQL Language Guide : 8. SQL Statements : UPDATE : WHERE Clause
 
Share this page                  
WHERE Clause
The WHERE clause specifies the search_conditions that rows of the table must satisfy in order to be updated.
Caution!  Use caution when using the UPDATE statement without a WHERE clause. The target columns are updated for all rows if conditions are not specified using the WHERE clause.