Mysql 5+ 定时执行任务

开启任务

SET GLOBAL event_scheduler = 1;
SELECT @@event_scheduler;

-------------------------------------------

创建每30秒执行任务

CREATE TABLE aaa (timeline TIMESTAMP);
CREATE EVENT e_test_insert
ON SCHEDULE EVERY 30 SECOND
DO INSERT INTO test.aaa VALUES(CURRENT_TIMESTAMP);

-------------------------------------------

终止任务

alter event e_test_insert ON
COMPLETION PRESERVE DISABLE;

-------------------------------------------

日期时间执行任务

CREATE EVENT e_test
ON SCHEDULE AT TIMESTAMP '2015-04-15 9:58:30'
DO INSERT INTO test.aaa VALUES(CURRENT_TIMESTAMP);