About MySQL [Err] 1451-cannot Delete or update a parent ROW:A FOREIGN KEY constraint fails

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"; Q Uery OK, 1 row affected (0.02 sec) mysql> SET foreign_key_checks = 1; Query OK, 0 rows Affected (0.00 sec)

SET foreign_key_checks = 0//Turn off FOREIGN KEY constraints

When you're done, don't forget to reopen the foreign key constraint. The following is a FOREIGN key constraint for opening the database:

SET foreign_key_checks = 1//Open FOREIGN KEY constraint

About MySQL [Err] 1451-cannot Delete or update a parent ROW:A FOREIGN KEY constraint fails