-- 创建带分区的表

CREATE TABLE d_0032108011000106020010001_0_1  (

  id int(11) NOT NULL AUTO_INCREMENT,

  dev_data varchar(255) NOT NULL,

  dev_time int(11) NOT NULL,

  PRIMARY KEY (`id`, `dev_time`)

)

partition by range columns(dev_time)

(partition p202004 values less than (1588262400));

-- 计划任务 增加分区

alter table d_0032108011000106020010001_0_1 add partition (partition p202005 values less than (1590940800));