语句如下:

    1. update_stmt:
    2. UPDATE table_factor
    3. SET column_assign_list
    4. [WHERE condition]
    5. [ORDER BY order_expression_list]
    6. [LIMIT limit_row_count];
    7. column_assign_list:
    8. column_assign [, column_assign ...]
    9. column_assign:
    10. column_name = expression
    11. condition:
    12. expression
    13. order_expression_list:
    14. order_expression [, order_expression ...]
    15. order_expression:
    16. expression [ASC | DESC]
    17. limit_row_count:
    18. INT_VALUE