mysql 按照月份分区

CREATE TABLE monthly_data (
    id INT AUTO_INCREMENT,
    data VARCHAR(255),
    date DATE,
    PRIMARY KEY (id, date)
) PARTITION BY RANGE (TO_DAYS(date)) (
    PARTITION p202201 VALUES LESS THAN (TO_DAYS('2022-02-01')),
    PARTITION p202202 VALUES LESS THAN (TO_DAYS('2022-03-01')),
    PARTITION p202203 VALUES LESS THAN (TO_DAYS('2022-04-01')),
    PARTITION p202204 VALUES LESS THAN (TO_DAYS('2022-05-01')),
    PARTITION p202205 VALUES LESS THAN (TO_DAYS('2022-06-01')),
    PARTITION p202206 VALUES LESS THAN (TO_DAYS('2022-07-01')),
    PARTITION p202207 VALUES LESS THAN (TO_DAYS('2022-08-01')),
    PARTITION p202208 VALUES LESS THAN (TO_DAYS('2022-09-01')),
    PARTITION p202209 VALUES LESS THAN (TO_DAYS('2022-10-01')),
    PARTITION p202210 VALUES LESS THAN (TO_DAYS('2022-11-01')),
    PARTITION p202211 VALUES LESS THAN (TO_DAYS('2022-12-01')),
    PARTITION p202212 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION pmax VALUES LESS THAN MAXVALUE
);

ALTER TABLE monthly_data ADD PARTITION (
    PARTITION p202301 VALUES LESS THAN (TO_DAYS('2023-02-01'))
);