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 p202301 VALUES LESS THAN (TO_DAYS('2023-02-01')),
    PARTITION p202302 VALUES LESS THAN (TO_DAYS('2023-03-01')),
    PARTITION p202303 VALUES LESS THAN (TO_DAYS('2023-04-01')),
    PARTITION p202304 VALUES LESS THAN (TO_DAYS('2023-05-01')),
    PARTITION p202305 VALUES LESS THAN (TO_DAYS('2023-06-01')),
    PARTITION p202306 VALUES LESS THAN (TO_DAYS('2023-07-01')),
    PARTITION p202307 VALUES LESS THAN (TO_DAYS('2023-08-01')),
    PARTITION p202308 VALUES LESS THAN (TO_DAYS('2023-09-01')),
    PARTITION p202309 VALUES LESS THAN (TO_DAYS('2023-10-01')),
    PARTITION p202310 VALUES LESS THAN (TO_DAYS('2023-11-01')),
    PARTITION p202311 VALUES LESS THAN (TO_DAYS('2023-12-01')),
    PARTITION p202312 VALUES LESS THAN (TO_DAYS('2024-01-01'))
);

DELIMITER //

CREATE EVENT monthly_partition_add
ON SCHEDULE EVERY 1 MONTH
STARTS CURRENT_DATE + INTERVAL 1 MONTH
DO
BEGIN
    DECLARE partition_name VARCHAR(255);
    DECLARE last_partition_date DATE;

    SET partition_name = CONCAT('p', YEAR(CURDATE() + INTERVAL 1 MONTH), LPAD(MONTH(CURDATE() + INTERVAL 1 MONTH), 2, '0'));
    SET last_partition_date = DATE_ADD(LAST_DAY(CURDATE() + INTERVAL 1 MONTH) + INTERVAL 1 DAY, INTERVAL -1 MONTH);

    SET @sql = CONCAT('ALTER TABLE monthly_data ADD PARTITION (PARTITION ', partition_name, ' VALUES LESS THAN (TO_DAYS(\'', last_partition_date, '\')));');

    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;