MENU


UPDATE

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET col_name1={expr1|DEFAULT}
[, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
UPDATE [LOW_PRIORITY] [IGNORE] table_references
SET col_name1={expr1|DEFAULT}
[, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
With the ORDER BY clause, the rows are updated in the order that is specified.
LIMIT limits the number of rows that can be updated.
LOW_PRIORITY delays the execution until the table is not being read. This affects storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE).
IGNORE suppresses errors.
An UPDATEoperation returns the number of rows that were changed.