Mysql删除表结构时报错:Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails
原因是Foreign Key的约束,通过关闭Foreign Key检查后,删除SQL表格成功:
Set FOREIGN_KEY_CHECKS = 0; 关闭Foreign Key检查
drop tableTable_Name;
SetFOREIGN_KEY_CHECKS= 1; 恢复Foreign Key检查
...
原创
2019-08-16 09:52:53 ·
2367 阅读 ·
0 评论