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

2004-11-22 Thread Duncan Hill
being thrown. > > ERROR 1216: Cannot add or update a child row: a foreign key constraint > fails Your data obviously has a row where the constraints are not valid. Either validate your data, or turn off the foreign key constraints temporarily when loading the data. -- MySQL General Mailing L

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

2004-11-22 Thread Dayakar
Hello list, I am getting the following error when i am loading data (Tab seperated data) into a table which has reference to a primary key table. There is data in the primary key table, but still this error is being thrown. ERROR 1216: Cannot add or update a child row: a foreign key constraint