1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> KEY_BLOCK_SIZE=8;
6
`a` int(11) DEFAULT NULL,
7
`b` char(8) DEFAULT NULL
8
) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=8
9
ALTER TABLE t1 KEY_BLOCK_SIZE=1;
12
t1 CREATE TABLE `t1` (
13
`a` int(11) DEFAULT NULL,
14
`b` char(8) DEFAULT NULL
15
) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1