MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: error 1452 "cannot add or update a child row: foreign key constaint fails"...
Posted by: Jonathan
Date: July 21, 2006 12:10PM

BILL!!!

Thank you!

geez that was easy. You have no idea how many hours i tried to figure this one out. Yeah, I was simply using notepad on my pc. Didn't know I needed to specificy the optional carriage return.

I did not specify the terminating of fields by \t, as that is the default (i think). So the problem must have been the lines terminated by '\r\n' not being present, as it is working now!

Again, thanks for your help.

Jonathan

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
error 1452 "cannot add or update a child row: foreign key constaint fails"...
Jonathan
July 20, 2006 09:13PM
Re: error 1452 "cannot add or update a child row: foreign key constaint fails"...
Jonathan
July 21, 2006 07:11AM
Re: error 1452 "cannot add or update a child row: foreign key constaint fails"...
Bill Karwin
July 21, 2006 10:01AM
Re: error 1452 "cannot add or update a child row: foreign key constaint fails"...
Jonathan
July 21, 2006 12:10PM


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.