mysql定时任务job_mysql定时任务job.doc

mysql定时任务job.doc

//**MYSQL 定时执行存储过程 查看 event 是否开启: show variables like %sche% ; 将事件计划开启: set global event_scheduler=1; 关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE; 开户事件任务: alter event e_test ON COMPLETION PRESERVE ENABLE; 简单实例. 创建表 CREATE TABLE test(endtime DATETIME); 创建存储过程 testCREATE PROCEDURE test ()BEGINupdate examinfo SET endtime = now() WHERE id = 14;END;创建 event e_testCREATE EVENT if not exists e_teston schedule every 30 secondon completion preservedo call test();每隔 30 秒将执行存储过程 test, 将当前时间更新到 examinfo 表中 id=14 的记录的 endtime 字段中去. //** MYSQL 取一个月前一个月后的时间date_add() 增加date_sub()减少month 月份minute 分钟second 秒例如：select DATE_ADD(NOW(),INTERVAL 1 MONTH); //一个月后的时间CREATE EVENT IF NOT EXISTS e_testON SCHEDULE EVERY 1 DAYSTARTS 2015-09-30 00:00:00 ON COMPLETION PRESERVEDO CALL test();例子： SET GLOBAL event_scheduler = ON; delimiter $$ drop event if exists e_wom_stat; create event e_wom_stat on schedule EVERY 1 day STARTS 2013-01-01 03:00:00 ON COMPLETION PRESERVE ENABLE do begin delete from t_wom_random_num where time