语句如下:
update_stmt:
UPDATE table_factor
SET column_assign_list
[WHERE condition]
[ORDER BY order_expression_list]
[LIMIT limit_row_count];
column_assign_list:
column_assign [, column_assign ...]
column_assign:
column_name = expression
condition:
expression
order_expression_list:
order_expression [, order_expression ...]
order_expression:
expression [ASC | DESC]
limit_row_count:
INT_VALUE