清空具有外键约束的表时报ERROR 1701(42000)的解决
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key
constraint
解决方法:
删除前
删除后
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key
constraint
解决方法:
删除前
SET foreign_key_checks=0;
删除后
SET foreign_key_checks=1;