Re: which constraint fails

[SGreen]

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