| 用途 | 删除行/清空表 |
|---|---|
| DELETE | 可 WHERE、走事务、回滚段大 |
| TRUNCATE | DDL、隐式提交、重置自增 |
用法对比
用法对比
DELETE FROM logs WHERE created_at < '2026-01-01' LIMIT 5000;
TRUNCATE TABLE staging_import;大表清理建议
大表清理建议
-- 分批删除避免长事务
DELETE FROM logs WHERE created_at < '2026-01-01' ORDER BY id LIMIT 5000;TRUNCATE 是 DDL 语义：隐式提交事务、不能回滚、会重置 AUTO_INCREMENT。