mysql8分区操作

官方分区指南
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html

1.需要设置进行分区的列为主键
不设置主键会出现报错；已经有主键的，设置复合主键可以解决这个问题
https://blog.csdn.net/tiansan/article/details/81388893
2.然后在进行分区
分区有很多种方法
以下使用的是根据月份进行分区

--month(jsrq) 为需要分区的列
ALTER TABLE js  PARTITION BY RANGE (month(jsrq))
  (
    PARTITION p_202101 VALUES LESS THAN (1),
    PARTITION p_202102 VALUES LESS THAN (2),
    PARTITION p_202103 VALUES LESS THAN (3),
    PARTITION p_202104 VALUES LESS THAN (4),
    PARTITION p_202105 VALUES LESS THAN (5),
    PARTITION p_202106 VALUES LESS THAN (6),
    PARTITION p_202107 VALUES LESS THAN (7),
    PARTITION p_202108 VALUES LESS THAN (8),
    PARTITION p_202109 VALUES LESS THAN (9),
    PARTITION p_202110 VALUES LESS THAN (10),
    PARTITION p_202111 VALUES LESS THAN (11),
    PARTITION p_202112 VALUES LESS THAN (12),
    PARTITION p_other  VALUES LESS THAN (MAXVALUE)
  )

建议参考下面的文章
https://blog.csdn.net/nklinsirui/article/details/106339892