SET FOREIGN_KEY_CHECKS = 0; TRUNCATE Table_Name; SET FOREIGN_KEY_CHECKS = 1;
mysql执行truncate命令报错:Cannot truncate a table referenced in a foreign key constraint
每天进步一点点~~~
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE Table_Name; SET FOREIGN_KEY_CHECKS = 1;