MySQL

[MySQL] 解决 Cannot truncate a table referenced in a foreign key constraint

2018-08-22 2018-08-22

方案: 先取消外键约束检查, 然后 truncate table, 最后再开启外键约束检查

1
2
3

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table $table_name;
SET FOREIGN_KEY_CHECKS = 1;