134
137
Table Create Table
135
138
t1 CREATE TABLE `t1` (
136
139
`a` int(11) DEFAULT NULL
137
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (a) (PARTITION p0 VALUES IN (10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53) ENGINE = MyISAM) */
140
) ENGINE=MyISAM DEFAULT CHARSET=latin1
141
/*!50100 PARTITION BY LIST (a)
142
(PARTITION p0 VALUES IN (10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53) ENGINE = MyISAM) */
138
143
SELECT PARTITION_DESCRIPTION FROM information_schema.partitions WHERE
139
144
table_schema = "test" AND table_name = "t1";
140
145
PARTITION_DESCRIPTION
141
146
10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53
148
drop table if exists t1;
149
create table t1 (f1 int key) partition by key(f1) partitions 2;
150
select create_options from information_schema.tables where table_schema="test";