UPDATE statement

Definition:

-s

UPDATE

1. [LOW_PRIORITY]
2. [IGNORE]
3. table_reference
4. SET assignment_list
   • assignment_list: assignment [, assignment] …
     • assignment: col_name = value
       • value: {expr | DEFAULT}
5. [WHERE where_condition]
6. [ORDER BY …]
7. [LIMIT row_count]