mysql设立定时执行
mysql设置定时执行?来自http://ajava.org/course/mysql/17196.html核心提示：查看event是否开启 showvariab
mysql设置定时执行
?
来自http://ajava.org/course/mysql/17196.html核心提示：查看event是否开启 showvariables like '%sche%' ; 将事件计划开户 setglobalevent_scheduler= 1 ; 创建存储过程test CREATE PROCEDURE test() BEGIN update examinfo SET endtime=now() WHERE id=14; END ; 创建event e_test create eventif not existse_te
? 查看event是否开启
- show?variables?like?'%sche%';??
? 将事件计划开户?
- set?global?event_scheduler?=1;??
?
? 创建存储过程test
- CREATE?PROCEDURE?test?() ?? BEGIN??
- update?examinfo?SET?endtime?=?now()?WHERE?id?=?14; ?? END;??
?
? 创建event e_test
- create?event?if?not?exists?e_test ?? on?schedule?every?30?second??
- on?completion?preserve ?? do?call?test();??
?
? 每隔30秒将执行存储过程test,将当前时间更新到examinfo表中id=14的记录的endtime字段中去.
?
? 关闭事件任务
- alter?event?e_test?ON? ?? COMPLETION?PRESERVE?DISABLE;??
?
? 开户事件任务
- alter?event?e_test?ON? ?? COMPLETION?PRESERVE?ENABLE; ??
?
