查看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!!!!!