mysql删除数据提示Cannot delete or update

今天在mysql删除条目报错Cannot delete or update a parent row:a foreign key constraint fails 错误,下面我们一看解决办法.

在SQLyog中删除条目出现Cannot delete or update a parent row:a foreign key constraint fails//phpfensi.com

原因是MySQL在InnoDB中设置了foreign key关联,造成无法更新或删除数据.

如果需要强制删除可以做如下操作:SET FOREIGN_KEY_CHECKS = 0;

执行上面的语句后就可以删除了,删除之后为了确保数据库的之前的设置正确别忘记:

SET FOREIGN_KEY_CHECKS = 1;

·解决Navicat cannot proceed because system tables办法(2014-09-24)
·mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication(2014-10-13)
·Navicat 导出mysql数据库的时候出现 “Cannot proceed because system(2015-04-18)
·解决mysqlnd cannot connect to MySQL 4.1+ using the old insec(2015-04-20)
·mysql中删除记录TRUNCATE与DELETE区别(2014-09-24)
·限制MySQL Delete语句删除数据(2014-10-02)
·MYSQL中delete删除多表数据与删除关联数据(2014-10-02)
·MySQL防止delete命令删除数据(2014-10-03)
·MySQL 删除数据 Delete 与Truncate语句比较(2014-10-12)
·sql中truncate,delete,drop的区别(2014-10-15)
·sql delete同时删除多表相关联记录(2014-10-17)
·Oracle8的不安全因素及几点说明(2013-11-14)
·coreseek sphinx 创建表和索引的语句(2014-09-23)
·解决MySQL启动的error 2003和1067 10061错误问题(2014-09-23)
·mysql提示Got error 28 from storage engine问题解决方法(2014-09-23)
·解决MySql Error:Host is blocked because of many connection errors问题(2014-09-24)

相关文章