Answers for "cannot update child row foreign key constraint fails"

0

Cannot add or update a child row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS=0
Posted by: Guest on July-09-2021
0

child row: a foreign key constraint fails

I discovered another weird case: If you accidentally create a foreign key from an InnoDB table to a MyISAM table, MySQL throws this error at time of insert even if the data is otherwise valid.
Posted by: Guest on July-04-2021

Code answers related to "cannot update child row foreign key constraint fails"

Browse Popular Code Answers by Language