On Monday 22 November 2004 13:10, Dayakar might have typed: > 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 > 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 List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]