mysql-test/suite/storage_engine/tbl_temporary.result
raw| 1 | DROP TABLE IF EXISTS t1; |
| 2 | CREATE TABLE t1 (c CHAR(1)) ENGINE=MyISAM; |
| 3 | CREATE TEMPORARY TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; |
| 4 | SHOW CREATE TABLE t1; |
| 5 | Table Create Table |
| 6 | t1 CREATE TEMPORARY TABLE `t1` ( |
| 7 | `a` int(11) DEFAULT NULL, |
| 8 | `b` char(8) DEFAULT NULL |
| 9 | ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 |
| 10 | DROP TEMPORARY TABLE t1; |
| 11 | DROP TABLE t1; |