Delete foreign key limit record

Cannot delete or update a parent row: A foreign key constraint fails ('myreview/zmax_text ', constraint 'zmax _ text_ibfk_1' foreign key ('lang ') references 'zmax _ Lang '('lang '))

 

The above is because a field of the record is changed to the external chain of another table in InnoDB. The external link is automatically checked during the delete operation. One solution is not to check the external links.

 

• Set foreign_key_checks = 0; // coma foreign_key
• Then you have done all the things you want to do while foreign_key is still in a coma. Come on!
• Set foreign_key_checks = 1; // Let foreign_key wake up.