mysql定时任务简单例子

如果要每5秒执行以下语句

update tt set tt.update_time = now() where id = '1';INSERT INTO tt (tno,tname) VALUES (53,66);

可以给mysql建个定时任务，具体方法如下

delimiter //  /*设定语句终结符为 //，因存储过程语句用；结束*/

一、查看event是否开启

show variables like ‘%sche%’;

开启event_scheduler

set global event_scheduler = 1;

二、创建存储过程test

CREATE PROCRDURE test ()BEGINupdate tt set tt.update_time = now() where id = '1';INSERT INTO tt (tno,tname) VALUES (53,66);END

三、创建event e_test

create event if not exists e_teston schedule every 5 secondon completion preservedo call test();

每隔5秒将执行存储过程test

关闭事件任务

alter event e_test ON COMPLETION PRESERVE DISABLE;

开启事件任务

alter event e_test ON COMPLETION PRESERVE ENABLE;