Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM: > Hello, > > I have an InnoDB table running on MySQL 4.1.11 with multiple FK > constraints. I'm accessing it via JDBC from Java. > > When an FK constraint fails with error 1216 I need to know which of the > constraints failed. > > SHOW INNODB STATUS returns the following output > > ... > CONSTRAINT `u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`) > REFERENCES `u_device` (`DEVICE_ID`) > ... > > Is there a way of getting to the name of the last failed FK constraint > without using SHOW INNODB STATUS? What I need is the > 'u_registration_ibfk_1' from the above example. > > Any help is highly appreciated > > -- > Frank >
Have you looked at the results of SHOW INNODB STATUS; ? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
