查看event是否开启
show variables like '%sche%';
set global event_scheduler =1;
CREATE PROCEDURE test () BEGIN update examinfo SET endtime = now() WHERE id = 14; END;创建event e_test
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;