创建分区表
create table t_task_resource ( id int(11) NOT NULL AUTO_INCREMENT, task_id int not null , resource_type tinyint not null , check_type tinyint not null , camera_id int , room_id int , state tinyint , org_id int , user_id int , create_time datetime not null , reply varchar(128) , primary key (id, create_time) ) ENGINE = InnoDB PARTITION BY RANGE (TO_DAYS(create_time)) ( PARTITION p_t_task_resource_202006 VALUES LESS THAN (TO_DAYS('2020-07-01')), PARTITION p_t_task_resource_202007 VALUES LESS THAN (TO_DAYS('2020-08-01')), PARTITION p_t_task_resource_202008 VALUES LESS THAN (TO_DAYS('2020-09-01')), PARTITION p_t_task_resource_202009 VALUES LESS THAN (TO_DAYS('2020-10-01')), PARTITION p_t_task_resource_202010 VALUES LESS THAN (TO_DAYS('2020-11-01')), PARTITION p_t_task_resource_202011 VALUES LESS THAN (TO_DAYS('2020-12-01')) );新建分区
ALTER TABLE t_task_resource add partition ( PARTITION p_t_task_resource_202012 VALUES LESS THAN (TO_DAYS('2021-01-01')) );