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

Today in the MySQL, when a sudden appearance of this error message, it was forced, but after careful observation of the cause of the foreign key, this is due to delete the table when there is a foreign key association when there is a delete error, we can temporarily put the MYSQ database of FOREIGN KEY constraints to shut down, Please see below for specific methods:

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

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