mysql创建定时任务

use mis;

CREATE TABLE mis.aaa(timeline TIMESTAMP);

CREATE EVENT e_test_insert
ON SCHEDULE EVERY 1 second #1秒触发一次
DO INSERT mis.aaa VALUE(CURRENT_TIMESTAMP);

CREATE EVENT e_etl_orderinfo_insert
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 4 HOUR) #10点触发每天
DO insert into mis.etl_orderinfo select sysdate() as etl_date,t.* from orderinfo t