Cannot truncate a table referenced in a foreign key constraint ….
1 删除外键约束
SET foreign_key_checks = 0
2 truncate所有表
3 恢复外键
SET foreign_key_checks = 1
Cannot truncate a table referenced in a foreign key constraint ….
1 删除外键约束
SET foreign_key_checks = 0
2 truncate所有表
3 恢复外键
SET foreign_key_checks = 1