MySQL创建计划任务

#查看计划状态
show variables like 'event_scheduler';

#开启计划
set global event_scheduler = on;

#定义计划任务
CREATE EVENT e_module_interval
    ON SCHEDULE EVERY 1 DAY
    COMMENT 'this is a description'
    DO
        BEGIN
            #Call proc_action()
        END