mysql定时创建表

-- 创建一个存储过程来创建表
DELIMITER //
CREATE PROCEDURE CreateNewTable()
BEGIN
    DECLARE tableName VARCHAR(255);
    SET tableName = CONCAT('table_', DATE_FORMAT(NOW(), '%Y%m%d'));

    SET @sql = CONCAT('CREATE TABLE ', tableName, ' (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )');

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

-- 设置定时任务每天执行一次存储过程
CREATE EVENT IF NOT EXISTS CreateNewTableEvent
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_DATE
DO
CALL CreateNewTable();