Cannot delete or update a parent row: a foreign key constraint fails

Cannot delete or update a parent row: a foreign key constraint fails


只能在DOS下启动MySql，运行sql语句

关闭外键检测

SET FOREIGN_KEY_CHECKS = 0;

执行操作


SET FOREIGN_KEY_CHECKS = 1;


其他：

关闭唯一性校验

set unique_checks=0;

set unique_checks=1;