2020-11-09

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')),
);