DELETE FROM ORDER BY ... LIMIT ; 是什么？

DELETE FROM ORDER BY ... LIMIT ; 用于分批删除，避免一次删除过多导致长事务与主从延迟，属于「数据操作（DML）」相关命令。

DELETE FROM <t> ORDER BY ... LIMIT <n>; 命令详解

在终端执行 DELETE FROM logs WHERE status = 9 ORDER BY id LIMIT 1000; 即可。

分批删除，避免一次删除过多导致长事务与主从延迟

命令语法

      DELETE FROM <t> ORDER BY ... LIMIT <n>;      高危    

命令说明

分批删除，避免一次删除过多导致长事务与主从延迟

示例

$ DELETE FROM logs WHERE status = 9 ORDER BY id LIMIT 1000;

DELETE FROM <t> ORDER BY ... LIMIT <n>; 是「数据操作（DML）」分类下的常用命令，作用是：分批删除，避免一次删除过多导致长事务与主从延迟。

典型用法如下：DELETE FROM logs WHERE status = 9 ORDER BY id LIMIT 1000;。你可以查看本页上方同组的相关命令，或直接复制到终端运行。

DELETE FROM <t> ORDER BY ... LIMIT <n>; 是什么？

DELETE FROM <t> ORDER BY ... LIMIT <n>; 用于分批删除，避免一次删除过多导致长事务与主从延迟，属于「数据操作（DML）」相关命令。

DELETE FROM <t> ORDER BY ... LIMIT <n>; 怎么用？

在终端执行 DELETE FROM logs WHERE status = 9 ORDER BY id LIMIT 1000; 即可，具体参数请按实际环境调整。

还有哪些相关命令？

数据操作（DML）分类下还有 14 条相关命令，见本页上方「相关命令」。