mysql 动态日期创建表

DELIMITER //

CREATE PROCEDURE CreateDailyTable()
BEGIN
    DECLARE tableName VARCHAR(255);
    DECLARE currentDate DATE;

    SET currentDate = CURDATE();
    SET tableName = CONCAT('log_', DATE_FORMAT(currentDate, '%Y%m%d'));

    SET @sql = CONCAT('CREATE TABLE IF NOT EXISTS ', tableName, ' (
        id INT AUTO_INCREMENT PRIMARY KEY,
        message TEXT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    ) PARTITION BY RANGE (TO_DAYS(created_at)) (
        PARTITION p0 VALUES LESS THAN (TO_DAYS(\'', currentDate, '\')),
        PARTITION p1 VALUES LESS THAN MAXVALUE
    )');

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

DELIMITER ;

CALL CreateDailyTable();