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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to