定时任务

— 创建存储过程 update_xx (注：就是你要执行的sql语句)
mysql> CREATE PROCEDURE update_a() UPDATE a SET a.chengji=NOW();
— 创建一个定时任务：event e_updateA
CREATE EVENT IF NOT EXISTS e_updateA
ON SCHEDULE EVERY 24 HOUR
STARTS ‘2015-01-01 00:20:00’
ON COMPLETION PRESERVE DO CALL PRO_GET_TMALL_ORDER1();
— 创建存储过程 update_xx (注：就是你要执行的sql语句)
mysql> CREATE PROCEDURE update_a() UPDATE a SET a.chengji=NOW();
— 创建一个定时任务：event e_updateA
CREATE EVENT IF NOT EXISTS e_updateA
ON SCHEDULE EVERY 24 HOUR
STARTS ‘2015-01-01 00:20:00’
ON COMPLETION PRESERVE DO CALL PRO_GET_TMALL_ORDER1();
— 关闭事件任务
ALTER EVENT e_updateA ON COMPLETION PRESERVE DISABLE;
— 开启事件任务
ALTER EVENT e_updateA ON COMPLETION PRESERVE ENABLE;