MySQL Forums
Forum List  »  Newbie

Re: PLS HELP: ERROR 1452 (23000) Foreign Key Constraint
Posted by: Roland Chan
Date: April 05, 2011 11:13PM

Just upgraded to 5.5.11 and same error:

ERROR 1452 (23000) at line 55: Cannot add or update a child row: a foreign key constraint fails (`constraint_test`.`beneficiary`, CONSTRAINT `FK41BADEC55CE3480` FOREIGN KEY (`insured_id`) REFERENCES `Insured` (`insured_id`))

Peter, may I ask, did you run execute it from the command line? Like so:

mysql constraint_test < ./constraint-test.sql

BTW, I am running on Mac OS X 10.6 not that I think it should matter...

Any suggestions would be appreciated, please.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.