UPDATE
For the first syntax, UPDATE modifies the contents of existing rows in the table tbl_name. The second UPDATE syntax is like the first, but enables multiple tables to be named to perform a multiple-table update. The syntax for tbl_refs is like that for SELECT, except that you cannot specify a subquery as a table.
The rows to be updated are those selected by the expression specified in the WHERE clause. For those rows that are selected, each column named in the SET clause is set to the value of the corresponding expression.
The WHERE clause ...
Get MySQL® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
