List:General Discussion« Previous MessageNext Message »
From:SGreen Date:February 9 2006 2:20pm
Subject:Re: which constraint fails
View as plain text  
Przemysław Klein <p.klein@stripped> wrote on 02/09/2006 04:24:14 AM:

> Hi All.
> How can I get to know which constraint fails when "Cannot delete or 
> update a parent row: a foreign key constraint fails" error occurs?
> Thanks in advance
> prp

If you issue a SHOW InnoDB STATUS command, you will get the details you 
are looking for. It's near the beginning of the status dump.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
which constraint failsPrzemysław Klein9 Feb
  • Re: which constraint failsSGreen9 Feb