UPDATE LOW_PRIORITY IGNORE table_reference SET assignment_list WHERE w

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET assignment_list
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
value:
{expr | DEFAULT}
assignment:
col_name = value
assignment_list:
assignment [, assignment] ...