Mysql 创建定时任务
上一篇 /
下一篇 2014-10-15 15:32:42
/ 个人分类:Mysql
使event起作用,MySQL的常量GLOBAL event_scheduler必须为on或者是1。 查看定时器是否开启:
SHOW VARIABLES LIKE 'event_scheduler';
开启定时器:
SET GLOBAL event_scheduler = 1;
查询event:
show events ;
创建event:
CREATE EVENT IF NOT EXISTS e_test
ON SCHEDULE EVERY 1 SECOND
ON COMPLETION PRESERVE
DO CALL e_test();
修改event:
ALTER EVENT e_test
ON SCHEDULE EVERY 1 week STARTS '2014-10-19 23:30:00'
ON COMPLETION PRESERVE
DO CALL e_test();
删除event:
DROP EVENT
[IF EXISTS]
event_name
收藏
举报
TAG: