Przemysław Klein <[EMAIL PROTECTED]> 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