[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?
[EMAIL PROTECTED] wrote:
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
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
My understanding is that RESTRICT and NO ACTION share the same behavior.
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
*
|NO ACTION|: In |ANSI SQL-92| standard, |NO ACTION| means /no
action/ in the sense that an attempt to delete or update a primary