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

1 개요

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

SQL 쿼리

ALTER TABLE `post_tag` ADD  FOREIGN KEY (`post_id`) REFERENCES `posts`(`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

MySQL 응답

#1452 - Cannot add or update a child row: a foreign key constraint fails (`ldb`.`#sql-58b_43cc8`, CONSTRAINT `#sql-58b_43cc8_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE)

2 같이 보기

• Error creating foreign key on tag_id (check data types)

3 참고

• https://stackoverflow.com/questions/21659691/error-1452-cannot-add-or-update-a-child-row-a-foreign-key-constraint-fails