亚洲 欧美 日韩 综合_人妻中文字幕一区_中文字幕有码在线播放_中文字幕+乱码+中文字幕明步_99热这里只有精品66_av在线天堂网_天天爱天天做天天爽_十八禁一区二区三区_丰满人妻一区二区三区53视频_亚洲无在线观看

CREATE TABLE aaa (timeline TIMESTAMP);

CREATE EVENT e_test_insert ON SCHEDULE EVERY 1 SECOND 
 DO INSERT INTO aaa VALUES (CURRENT_TIMESTAMP);

-- 每天定時情況aaa表 CREATE EVENT e_test on schedule every 1 DAY starts timestamp '2016-12-19 12:00:00' do truncate table aaa;

-- 每天定時情況aaa表，5天后停止執行 drop event if exists e_test; create event e_test on schedule every 1 day ends current_timestamp + INTERVAL 5 day do truncate table aaa;

-- 5天后開啟每天定時清空test表，一個月后停止執行 CREATE EVENT e_test ON SCHEDULE EVERY 1 DAY STARTS CURRENT_TIMESTAMP + INTERVAL 5 DAY ENDS CURRENT_TIMESTAMP + INTERVAL 1 MONTH DO TRUNCATE TABLE aaa;