mysql定时任务job

//**MYSQL定时执行存储过程查看event是否开启:showvariableslike'%sche%';将事件计划开启:setglobalevent_scheduler=1;关闭事件任务:alterevente_testONCOMPLETIONPRESERVEDISABLE;开户事件任务:alterevente_testONCOMPLETIONPRESERVEENABLE;简单实例.创建表CREATETABLEtest(endtimeDATETIME);创建存储过程testCREATEPROCEDUREtest()BEGINupdateexaminfoSETendtime=now()WHEREid=14;END;创建evente_testCREATEEVENTifnotexistse_testonscheduleevery30secondoncompletionpreservedocalltest();每隔30秒将执行存储过程test,将当前时间更新到examinfo表中id=14的记录的endtime字段中去.//**MYSQL取一个月前一个月后的时间date_add()增加date_sub()减少month月份minute分钟second秒例如：selectDATE_ADD(NOW(),INTERVAL1MONTH);//一个月后的时间CREATEEVENTIFNOTEXISTSe_testONSCHEDULEEVERY1DAYSTARTS'2015-09-3000:00:00'ONCOMPLETIONPRESERVEDOCALLtest();例子：SETGLOBALevent_scheduler=ON;delimiter$$dropeventifexistse_wom_stat;createevente_wom_statonscheduleEVERY1daySTARTS'2013-01-0103:00:00'ONCOMPLETIONPRESERVEENABLEdobegindeletefromt_wom_random_numwheretime(CURRENT_TIMESTAMP()+INTERVAL-25MINUTE);end$$delimiter;