问题
执行删除表语句:
DROP TABLE zyldb.constants_code
出现如下错误:
ERROR: (conn=142) Cannot delete or update a parent row: a
foreign key constraint fails Error Code: 1217
Query = DROP TABLE zyldb.constants_code
解决
SET foreign_key_checks = 0;
DROP TABLE zyldb.constants_code
SET foreign_key_checks = 1;
关闭对外键的检查后,然后,重新执行删除语句,再恢复对外键的检查。
参考
Fix for MySQL error Code 1217 – A foreign key constraint fails