mysql 自动创建分区表_Mysql分区表及自动创建分区Partition

Range分区表建表语句如下，其中分区键必须和id构成主键和唯一键

CREATE TABLE `test1` (

`id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘自增主键(guid)‘,

`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间‘,

`partition_key` int(8) NOT NULL COMMENT ‘分区键(格式:yyyyMMdd)‘,

PRIMARY KEY (`id`,`partition_key`),

UNIQUE KEY `id_UNIQUE` (`id`,`partition_key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

PARTITION BY RANGE (partition_key)

(PARTITION p0 VALUES LESS THAN (20180619) ENGINE = InnoDB,

PARTITION p20180619 VALUES LESS THAN (20180620) ENGINE = InnoDB,

PARTITION p20180621 VALUES LESS THAN (20180622) ENGINE = InnoDB,

PARTITION p20180622 VALUES LESS THAN (20180623) ENGINE = InnoDB,

PARTITION p20180623 VALUES LESS THAN (2