Re: Tracing a constraint problem

[Michael Stassen]

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