DROP TABLE IF EXISTS t1; CREATE TABLE t1(a INT) ENGINE=innodb; LOCK TABLES t1 WRITE; INSERT INTO t1 VALUES(10); SELECT * FROM t1; a 10 DROP TABLE t1;