伊人色综合网久久天天-伊人22综合-成人午夜精品无码一区二区三区-亚洲va欧美va国产综合-欧美国产一区二区三区-成人免费毛片糖心-国产a大片-高清一区二区三区免费视频-久久高潮视频-婷婷毛片-3d动漫精品一区二区三区-天天澡日日澡狠狠欧美老妇-欧美第一浮力影院-中文字幕丝袜精品久久-尤物爽到高潮潮喷视频大全

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天后停止執(zhí)行 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表，一個月后停止執(zhí)行 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;