-
Mysql事件查看及定时器相关操作查看事件SHOW EVENTSselect * from mysql.event查看是否开启定时器SHOW VARIABLES LIKE 'event_scheduler';开启定时器 0:off 1:onSET GLOBAL event_scheduler = 1; .删除drop EVENT *_event;创建CREATE EVENT IF NOT EXISTS *_event_testON SCHEDULE every 1 HourDO CALL update_*_proc();或者CREATE EVENT IF NOT EXISTS update_*_eventON SCHEDULE every 1 DAY STARTS TIMESTAMP(CURRENT_DATE,'00:05:00')ON COMPLETION PRESERVE ENABLEDO CALL update_*_proc();date_add(date(curdate() + 1),interval 8 hour)
-
原文链接:http://www.2cto.com/database/201305/208732.html