MySQL 利用触发器调用存储过程定时创建分表

DELIMITER //
CREATE PROCEDURE create_table()
BEGIN
    DECLARE `@suffix` VARCHAR(15);
    DECLARE `@sql_str` VARCHAR(2560);
    SET `@suffix` = DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 MONTH),'_%Y%m');
    SET @sql_str = CONCAT("CREATE  TABLE IF NOT EXISTS test",`@suffix`," LIKE test;");
    PREPARE stmt FROM @sql_str;
    EXECUTE stmt;
END;

DELIMITER $$
CREATE EVENT event_create_table
ON SCHEDULE
EVERY  1  MONTH
STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())+1 DAY), INTERVAL 0 MONTH),INTERVAL 0 HOUR)
ON  COMPLETION  PRESERVE
ENABLE
DO
 BEGIN
    CALL create_table();
 END$$
DELIMITER ;

SHOW VARIABLES LIKE 'event%';