mysql批量清空表格

-- 检查是否有锁
SHOW ENGINE INNODB STATUS;

-- 解锁表（如果有必要）
UNLOCK TABLES;

-- 删除外键约束（如果有）
ALTER TABLE table_name DROP FOREIGN KEY constraint_name;

-- 再次尝试TRUNCATE TABLE
TRUNCATE TABLE table_name;

-- 使用TRUNCATE TABLE代替DELETE
TRUNCATE TABLE table_name;

-- 分批删除数据
SET @batch_size = 1000;
REPEAT
    DELETE FROM table_name LIMIT @batch_size;
UNTIL ROW_COUNT() = 0 END REPEAT;

-- 使用TRUNCATE TABLE批量清空多个表
TRUNCATE TABLE table1, table2, table3;

-- 使用DELETE FROM批量清空多个表（分批删除）
SET @batch_size = 1000;
REPEAT
    DELETE FROM table1 LIMIT @batch_size;
    DELETE FROM table2 LIMIT @batch_size;
    DELETE FROM table3 LIMIT @batch_size;
UNTIL (SELECT COUNT(*) FROM table1) = 0 AND (SELECT COUNT(*) FROM table2) = 0 AND (SELECT COUNT(*) FROM table3) = 0 END REPEAT;