List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:August 24 2005 4:19am
Subject:Re: Tracing a constraint problem
View as plain text  
Marcus Bointon wrote:
> I have a single-table update query that's giving me a "Cannot add or  
> update a child row: a foreign key constraint fails" error. Fair  enough, 
> I do have several constraints defined - but how can I find  out which 
> constraint is failing?
> 
> Marcus

   SHOW INNODB STATUS

See the manual for details 
<http://dev.mysql.com/doc/mysql/en/innodb-monitor.html>.

Michael
Thread
Tracing a constraint problemMarcus Bointon24 Aug
  • Re: Tracing a constraint problemMichael Stassen24 Aug
    • Re: Tracing a constraint problemMarcus Bointon24 Aug