MySQL 创建定时任务

#查看是否开启事务
SHOW VARIABLES LIKE '%sche%'

#开启事务
set global event_scheduler=1;
#关闭事务
set global event_scheduler=0;

#查看创建的定时任务
show events;
#或者
select * from mysql.event;

#创建存储过程
CREATE PROCEDURE insert_user1()
    BEGIN
        INSERT INTO `xnew`.`user1` (`name1`) VALUES ('3');
    END;

#调用存储过程
CALL  insert_user1();

#创建定时任务
-- 每天0点执行
create event if not EXISTS my_monitor
on schedule every  1 DAY STARTS date(CURRENT_DATE+1)
on completion preserve  do call insert_user1();

create event if not exists e_test
on schedule every 30 second
on completion preserve
do call insert_user1();
-- -----------------------------------

#删除定时任务
drop event e_test

#关闭事件任务
alter event e_test ON COMPLETION PRESERVE DISABLE;

#开启事件任务
alter event e_test ON COMPLETION PRESERVE ENABLE;