MySQL Cannot truncate a table referenced in a foreign key constraint 方案: 先取消外键约束检查, 然后 truncate table, 最后再开启外键约束检查 1 2 3 SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table $table_name; SET FOREIGN_KEY_CHECKS = 1;