mysql创建表后新增分区

前提：分区的字段名必须是主键的一部分
ALTER TABLE 表名 PARTITION BY LIST COLUMNS(字段名)
(PARTITION p2017 VALUES IN (‘2017’) ENGINE = InnoDB,
PARTITION p2018 VALUES IN (‘2018’) ENGINE = InnoDB,
PARTITION p2019 VALUES IN (‘2019’) ENGINE = InnoDB,
PARTITION p2020 VALUES IN (‘2020’) ENGINE = InnoDB,
PARTITION p2021 VALUES IN (‘2021’) ENGINE = InnoDB,
PARTITION p2022 VALUES IN (‘2022’) ENGINE = InnoDB,
PARTITION p2023 VALUES IN (‘2023’) ENGINE = InnoDB,
PARTITION p2024 VALUES IN (‘2024’) ENGINE = InnoDB);