mysql drop 多列_MySQL多列分区

drop table if exists partition_test;CREATE TABLE `partition_test` (

`t_id` int(11) NOT NULL AUTO_INCREMENT,

`test_date` datetime NOT NULL,

`t_key` varchar(16),

`test_info` varchar(50) DEFAULT 'test',

PRIMARY KEY (`t_id`,`test_date`,`t_key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

PARTITION BY RANGE COLUMNS (test_date,t_key)

(

PARTITION p201303151 VALUES LESS THAN ('2013-03-15','m2'),

PARTITION p201303152 VALUES LESS THAN ('2013-03-15','m3'),

PARTITION p201303161 VALUES LESS THAN ('2013-03-16','m2'),

PARTITION p201303162 VALUES LESS THAN ('2013-03-16','m3'),

PARTITION p201303171 VALUES LESS THAN ('2013-03-17','m2'),

PARTITION p201303172 VALUES LESS THAN ('2013-03-17'