MySQL定時任務簡單例子

    如果要每30秒執行以下語句：

update userinfo set endtime = now() WHERE id = '110';

delimiter //   /* 設定語句終結符為 //，因存儲過程語句用;結束 */

一、查看event是否開啟

show variables like '%sche%';

set global event_scheduler =1;

CREATE PROCEDURE test ()
BEGIN
update userinfo set endtime = now() where id = '110';
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;