mysql 分区实现_mysql实现分区表

1.普通转分区表

create_day 分区字段(一般以时间分区，需要把时间转int类型)

ALTER TABLE TABLE_NAME PARTITION BY RANGE ( create_day ) ( PARTITION p20190101 VALUES LESS THAN ( 20190101 ), PARTITION p888666 VALUES LESS THAN MAXVALUE );

2.给分区唯一值字段

(PRIMARY KEY；UNIQUE KEY)加上分区表字段

3.添加分区

alter table table_name add partition(

PARTITION p20210201 VALUES LESS THAN (20210201),

PARTITION p20210301 VALUES LESS THAN (20210301),

PARTITION p20210401 VALUES LESS THAN (20210401),

PARTITION p20210501 VALUES LESS THAN (20210501),

PARTITION p20210601 VALUES LESS THAN (20210601),

PARTITION p20210701 VALUES LESS THAN (20210701),

PARTITION p20210801 VALUES LESS THAN (20210801),

PARTITION p20210901 VALUES LESS THAN (20210901),

PARTITION p20211001 VALUES LESS THAN (20211001),

PARTITION p20211101 VALUES LESS THAN (20211101),

PARTITION p20211201 VALUES LESS THAN (20211201)

);