22,301
社区成员




DELETE TABLE WHERE ID IN (SELECT TOP 10000 ID FROM TABLE ORDER BY ID)
DELETE tableA FROM t_table_a tableA,(SELECT id FROM t_table_a WHERE is_valid = 0 LIMIT 10000) tableB
WHERE tableA.id = tableB.id
--1. 增加中间表 tmp(autoId, id), 将要删除的 id 插入到 tmp 表中. autoId 为自增长列
--2. 循环删除,每次删除 100 条数据,太多可能导致卡死
DELETE FROM t
FROM t INNER JOIN tmp ON t.id=tmp.id
WHERE autoId<=100