| 1 |
--source include/have_innodb.inc |
| 2 |
|
| 3 |
SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_LOCKS; |
| 4 |
|
| 5 |
CREATE TEMPORARY TABLE t1 LIKE INFORMATION_SCHEMA.INNODB_LOCKS; |
| 6 |
DROP TEMPORARY TABLE t1; |
| 7 |
|
| 8 |
CREATE TEMPORARY TABLE t1 AS SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS LIMIT 0; |
| 9 |
DROP TEMPORARY TABLE t1; |