mysql自动按天分区

CREATE TABLE daily_data (
    id INT AUTO_INCREMENT,
    data VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id, created_at)
) PARTITION BY RANGE (TO_DAYS(created_at)) (
    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 pmax VALUES LESS THAN MAXVALUE
);

DELIMITER $$

CREATE EVENT auto_partition_event
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_DATE + INTERVAL 1 DAY
DO
BEGIN
    DECLARE partition_name VARCHAR(255);
    DECLARE max_date DATE;
    SET max_date = (SELECT MAX(created_at) FROM daily_data);
    SET partition_name = CONCAT('p', DATE_FORMAT(DATE_ADD(max_date, INTERVAL 1 DAY), '%Y%m%d'));

    SET @sql = CONCAT('ALTER TABLE daily_data ADD PARTITION (PARTITION ', partition_name, ' VALUES LESS THAN (TO_DAYS(\'', DATE_ADD(max_date, INTERVAL 1 DAY), '\')))');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$$

DELIMITER ;