Re: How to get the name of the last failed FK constraint

[Frank Schröder]

[EMAIL PROTECTED] wrote:

Hi,
Status;

gives your own session id. To be combined to show innodb status (ksh or perl).

Mathias


I'm not sure I understand.

Are you saying that SHOW INNODB STATUS shows only the information of the 
current session or that I can supply a session id to the call?


--
Frank

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

How to get the name of the last failed FK constraint

[Frank Schröder]

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

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


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

How to get the name of the last failed FK constraint

[Frank Schröder]

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

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