mysql 分区表

DROP TABLE  IF EXISTS T1;CREATE TABLE T1(   ID             INT NOT NULL,   C1                 CHAR(15) NOT NULL,   DATATIME             DATETIME NOT NULL,   PRIMARY KEY (ID, C1, DATATIME)) ENGINE=INNODB DEFAULT CHARSET=utf8PARTITION BY RANGE (TO_DAYS(DATATIME)) ( PARTITION p201701 VALUES LESS THAN (TO_DAYS('2017-02-01')),PARTITION p201702 VALUES LESS THAN (TO_DAYS('2017-03-01')),PARTITION p201703 VALUES LESS THAN (TO_DAYS('2017-04-01')),PARTITION p201704 VALUES LESS THAN (TO_DAYS('2017-05-01')),PARTITION p201705 VALUES LESS THAN (TO_DAYS('2017-06-01')),PARTITION p201706 VALUES LESS THAN (TO_DAYS('2017-07-01')),PARTITION p201707 VALUES LESS THAN (TO_DAYS('2017-08-01')),PARTITION p201708 VALUES LESS THAN (TO_DAYS('2017-09-01')),PARTITION p201709 VALUES LESS THAN (TO_DAYS('2017-10-01')),PARTITION p201710 VALUES LESS THAN (TO_DAYS('2017-11-01')),PARTITION p201711 VALUES LESS THAN (TO_DAYS('2017-12-01')),PARTITION p201712 VALUES LESS THAN (TO_DAYS('2018-01-01')));INSERT INTO T1(ID, C1, DATATIME) VALUES(1,'00001','2017-03-15 09:00:00'),(1,'00001','2017-02-15 09:00:00');SELECT * FROM T1 PARTITION(p201702);SELECT * FROM T1 PARTITION(p201702,p201703)-- 如果是整形的CREATE TABLE IF NOT EXISTS T1(     ID             INT NOT NULL,     C1                 CHAR(15) NOT NULL,     DATATIME             BIGINT NOT NULL,     PRIMARY KEY (ID, C1, DATATIME)  ) ENGINE=INNODB DEFAULT CHARSET=utf8   PARTITION BY RANGE(TSTAMP)   (   PARTITION p1 VALUES LESS THAN (UNIX_TIMESTAMP('2017-02-01')) ENGINE=INNODB,   PARTITION p2 VALUES LESS THAN (UNIX_TIMESTAMP('2017-03-01')) ENGINE=INNODB,   PARTITION p3 VALUES LESS THAN (UNIX_TIMESTAMP('2017-04-01')) ENGINE=INNODB,   PARTITION p4 VALUES LESS THAN (UNIX_TIMESTAMP('2017-05-01')) ENGINE=INNODB,   PARTITION p5 VALUES LESS THAN (UNIX_TIMESTAMP('2017-06-01')) ENGINE=INNODB,   PARTITION p6 VALUES LESS THAN (UNIX_TIMESTAMP('2017-07-01')) ENGINE=INNODB,   PARTITION p7 VALUES LESS THAN (UNIX_TIMESTAMP('2017-08-01')) ENGINE=INNODB,   PARTITION p8 VALUES LESS THAN (UNIX_TIMESTAMP('2017-09-01')) ENGINE=INNODB,   PARTITION p9 VALUES LESS THAN (UNIX_TIMESTAMP('2017-10-01')) ENGINE=INNODB,   PARTITION p10 VALUES LESS THAN (UNIX_TIMESTAMP('2017-11-01')) ENGINE=INNODB,   PARTITION p11 VALUES LESS THAN (UNIX_TIMESTAMP('2017-12-01')) ENGINE=INNODB,   PARTITION p12 VALUES LESS THAN (UNIX_TIMESTAMP('2018-01-01')) ENGINE=INNODB);