MkgbpNkm

1CREATE TABLE if not exists `test` (
2        `id`                BIGINT(20) NOT NULL AUTO_INCREMENT,
3        `result`            VARCHAR(128),
4         `update_time`           DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,        
5         KEY id (id)) 
6         ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1    
7         PARTITION BY RANGE ( TO_DAYS(update_time) ) (    
8         -- PARTITION BY hash (TO_DAYS(update_time)) partitions 31;
9                PARTITION p_first VALUES LESS THAN (TO_DAYS('2019-01-07 00:00:00')),
10                PARTITION p20190107 VALUES LESS THAN (TO_DAYS('2019-01-08 00:00:00')),
11                PARTITION p20190108 VALUES LESS THAN (TO_DAYS('2019-01-09 00:00:00'))
12        );
13
14                                                      
15insert into procinfo (id, result, update_time)
16values
17(2, 'a', '2019-01-08 11:11:11'),
18(3, 'a', '2019-01-07 11:11:11'),
19(1, 'a', '2019-01-02 11:11:11'),