Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_pack_keys.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PACK_KEYS=1;
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `a` int(11) DEFAULT NULL,
7 `b` char(8) DEFAULT NULL
8 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 PACK_KEYS=1
9 ALTER TABLE t1 PACK_KEYS=0;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `a` int(11) DEFAULT NULL,
14 `b` char(8) DEFAULT NULL
15 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 PACK_KEYS=0
16 DROP TABLE t1;