error:mysql删除报错Cannot delete or update a parent row (201

mysql> delete from repositories where repo_name= "watch/sinawatch_agent_update";

ERROR 1451 (23000): Cannot delete or update a parent row: aforeign key constraint fails (`rhodecode`.`repo_to_perm`,CONSTRAINT `repo_to_perm_ibfk_3` FOREIGN KEY (`repository_id`)REFERENCES `repositories` (`repo_id`))

这可能是MySQL在InnoDB中设置了foreignkey关联，造成无法更新或删除数据。可以通过设置FOREIGN_KEY_CHECKS变量来避免这种情况。

mysql> SET FOREIGN_KEY_CHECKS = 0;

Query OK, 0 rows affected (0.02 sec)

mysql> delete from repositories where repo_name= "watch/sinawatch_agent_update";

Query OK, 1 row affected (0.02 sec)

mysql> SET FOREIGN_KEY_CHECKS = 1;

Query OK, 0 rows affected (0.00 sec)




转自：http://blog.sina.com.cn/s/blog_8f31e5b1010156l1.html