MySQL定时执行任务_MySQL

show variables like '%sche%';

set global event_scheduler =1;

CREATE PROCEDURE test ()  BEGIN  update examinfo SET endtime = now() WHERE id = 14;  END; 

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

关闭事件任务

alter event e_test ON   COMPLETION PRESERVE DISABLE;

alter event e_test ON   COMPLETION PRESERVE ENABLE;