久草精品视频-精品久久久久久久久久久久久-美女网站免费-美女视频在线观看免费-色视频免费-激情五月小说-伊人热久久-亚洲色图日韩-日韩大片免费观看视频播放-波多野吉衣伦理片-爱的色放 韩国-男生草女生的视频-亚洲人成精品久久久久-色福利视频导航-91精品在线影院

CREATE TABLE aaa (timeline TIMESTAMP);

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

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

-- 每天定時(shí)情況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天后開啟每天定時(shí)清空test表，一個(gè)月后停止執(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;