MySQL的定时任务详解

show variables like '%event_sche%';
复制

set global event_scheduler = 1;
复制

create procedure test_procedure ()
begin
insert into user(name,create_date) values('hello',now());
end;
复制

create event run_event
on schedule every 1 minute
on completion preserve disable
do call test_procedure ();
复制

SELECT event_name,event_definition,interval_value,interval_field,status 
FROM information_schema.EVENTS;
复制

alter event run_event on completion preserve enable;  开启定时任务
alter event run_event on completion preserve disable; 关闭定时任务
复制

on schedule every 1 week //每周执行1次
复制

on schedule at current_timestamp()+interval 5 day //5天后执行
on schedule at '2019-01-01 00:00:00'              //在2019年1月1日，0点整执行
复制

on schedule every 1 day starts current_timestamp()+interval 5 day ends current_timestamp()+interval 1 month //5天后开始每天都执行执行到下个月底
on schedule every 1 day ends current_timestamp()+interval 5 day //从现在起每天执行，执行5天
复制