MySQL-设置定时任务

1、检查是否开启定时任务

SHOW VARIABLES LIKE 'event_scheduler';

2、开启定时任务配置

SET GLOBAL event_scheduler = ON;

3、创建任务

1）创建存储过程

CREATE DEFINER=`root`@`%` PROCEDURE `proc_read_group`()
BEGIN
    INSERT INTO biz_group_stat_copy1  
    SELECT * FROM biz_group_stat where customer_id = 61 ;   

    COMMIT;

END

2）创建定时

每隔 30 秒  30 SECOND

每隔1天 1 DAY

CREATE EVENT IF NOT EXISTS InsertDataEvent
ON SCHEDULE EVERY 30 SECOND
DO
BEGIN
    CALL proc_read_group();
END;
 

3）删除定时

drop EVENT InsertDataEvent;

 4）修改定时

ALTER EVENT InsertDataEvent ON SCHEDULE  EVERY 2 DAY;

5）查看定时任务

SHOW EVENTS;