MySQL Forums
Forum List  »  InnoDB

How to find which foreign key constraint fails
Posted by: jmf
Date: May 03, 2005 07:51AM


When trying to delete a record, I get this error message : "1217: Cannot delete or update a parent row: a foreign key constraint fails".

Since many fields from many tables are in relation with the id field of this table, it is hard to find where the error comes from.

Is there a way to create a map of the foreign key constraints for a database ?


Options: ReplyQuote

Written By
How to find which foreign key constraint fails
May 03, 2005 07:51AM

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.