MySQL Timer task Simple example

MySQL Timer task Simple example

?

123456789

如果要每30秒执行以下语句：[sql] update userinfo set endtime = now() WHERE id = ‘110‘;  可以给mysql建个定时任务，具体方法如下：[sql] delimiter //   /* 设定语句终结符为 //，因存储过程语句用;结束 */

First, check if the event is open?

12345

[sql] show variables like‘%sche%‘;  开启event_scheduler[sql] set globalevent_scheduler =1;

Second, create the stored procedure test?

12345

[sql] CREATEPROCEDURE test ()  BEGIN update userinfo set endtime = now() whereid = ‘110‘;  END;

Third, create event E_test?

1234567891011121314151617

[sql] create event if not exists e_test  on schedule every 30 secondon completion preserve  do call test();  每隔30秒将执行存储过程test关闭事件任务[sql] alter event e_test ON COMPLETION PRESERVE DISABLE;  开户事件任务[sql] alter event e_test ON COMPLETION PRESERVE ENABLE;

MySQL Timer task Simple example