MySQL创建时间分区表
以时间为节点(p2017__是分区名)
CREATE TABLE `stat_stock_all` (
`date` date NOT NULL,
`code` varchar(255) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`amount` varchar(255) DEFAULT NULL,
PRIMARY KEY (`date`,`code`)
)
PARTITION BY RANGE(TO_DAYS(`date`))
(
PARTITION p2017q1 VALUES LESS THAN (TO_DAYS('2017-04-01')),
PARTITION p2017q2 VALUES LESS THAN (TO_DAYS('2017-07-01')),
PARTITION p2017q3 VALUES LESS THAN (TO_DAYS('2017-10-01')),
PARTITION p2017q4 VALUES LESS THAN (TO_DAYS('2018-01-01')),
);