MySQL定时执行

查看event是否开启

show variables like '%sche%';

将事件计划开启

set global event_scheduler =1;

创建存储过程test

CREATE PROCEDURE timing_test()
BEGIN
update cdr SET date_time= now() WHERE id = 1;
END;

创建event e_test

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

每隔30秒将执行存储过程timing_test,将当前时间更新到cdr表中id=1的记录的date_time字段中去.

关闭事件任务

alter event e_test ON
COMPLETION PRESERVE DISABLE;

开户事件任务

alter event e_test ON
COMPLETION PRESERVE ENABLE;                           Good Luck!!!!!