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

answer re: ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

Mar 27 '19

112

The Problem is with FOREIGN KEY Constraint. By Default (SET FOREIGN_KEY_CHECKS = 1). FOREIGN_KEY_CHECKS option specifies whether or not to check foreign key constraints for InnoDB tables. MySQL - SET FOREIGN_KEY_CHECKS

We can set foreign key check as disable before running Query. Disable Foreign key.

Execute one of these…

Open Full Answer