开启任务
SELECT @@event_scheduler;
-------------------------------------------
创建每30秒执行任务
CREATE EVENT e_test_insert
ON SCHEDULE EVERY 30 SECOND
DO INSERT INTO test.aaa VALUES(CURRENT_TIMESTAMP);
-------------------------------------------
终止任务
COMPLETION PRESERVE DISABLE;
-------------------------------------------
日期时间执行任务
ON SCHEDULE AT TIMESTAMP '2015-04-15 9:58:30'
DO INSERT INTO test.aaa VALUES(CURRENT_TIMESTAMP);