mysql创建分区表

1.按天分区

CREATE TABLE 表名xxxxxxxxx (
id BIGINT ( 20 ) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
create_time date NOT NULL COMMENT ‘创建时间’,
PRIMARY KEY ( id,create_time)
) ENGINE = INNODB AUTO_INCREMENT = 29 DEFAULT CHARSET = utf8mb4 COMMENT = ‘表说明xxxxxxxx’
PARTITION BY RANGE COLUMNS ( create_time )
(PARTITION p20201130 VALUES LESS THAN ( ‘2020-11-30’ ) ENGINE = INNODB,
PARTITION p20201201 VALUES LESS THAN ( ‘2020-12-01’ ) ENGINE = INNODB);