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);