更新时间:2024-04-18 GMT+08:00
ORDER BY
如果一个MySQL UPDATE语句包含一个 ORDER BY子句,则这些行将按照该子句指定的顺序更新。
输入示例
1 2 |
# 测试 ORDER BY 语法点 UPDATE employees SET department_id=department_id+1 ORDER BY id; |
输出示例
1 2 |
-- 测试 ORDER BY 语法点 UPDATE "public"."employees" SET "department_id" = department_id+1; |
父主题: UPDATE