语法：
|
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [ORDER BY ...] [LIMIT rows] |
|
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]
SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] |
参数：
| 参数 | 意义 |
|---|---|
| LOW_PRIORITY | 低优先级，等到表空闲时执行 |
| IGNORE | 忽略字段重复引起的错误 |