mysql定时生成表分区

CREATE TABLE logs (
    id INT AUTO_INCREMENT,
    log_date DATE NOT NULL,
    message TEXT,
    PRIMARY KEY (id, log_date)
) PARTITION BY RANGE (TO_DAYS(log_date)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2023-02-01')),
    PARTITION p2 VALUES LESS THAN (TO_DAYS('2023-03-01')),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

DELIMITER $$

CREATE EVENT daily_partition_add
ON SCHEDULE EVERY 1 DAY
STARTS '2023-01-01'
DO
BEGIN
    DECLARE next_date DATE;
    SET next_date = DATE_ADD(CURDATE(), INTERVAL 1 DAY);
    SET @sql = CONCAT('ALTER TABLE logs ADD PARTITION (PARTITION p', DAYOFYEAR(next_date) - 1, ' VALUES LESS THAN (TO_DAYS(\'', next_date, '\')))');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$$

DELIMITER ;