1
2016
骞磋绠楁満浜岀骇鑰冨墠
MySQL
璇曢妯?
鎷熷強绛旀
1[
濉┖棰?/p>
](
)
鍏抽敭瀛楄兘澶熷皢涓や釜鎴栧涓?/p>
SELECT
璇彞鐨勭粨鏋滆繛鎺?/p>
璧锋潵銆?/p>
鍙傝�冭В鏋愶細
UNION
2[
濉┖棰?/p>
]5
澶╁悗寮�鍚瘡澶╁畾鏃舵竻绌?/p>
test
琛紝
涓�涓湀鍚庡仠姝㈡墽琛岋細
( ) EVENT e_test
ON SCHEDULE ( )
( ) CURDATE() +( )
ENDS CURDATE() + ( )
DO TRUNCATE TABLE test;
鍙傝�冭В鏋愶細
5
澶╁悗寮�鍚瘡澶╁畾鏃舵竻绌?/p>
test
琛紝涓�涓湀鍚庡仠姝㈡墽
琛岋細
CREATE EVENT e_test
ON SCHEDULE EVERY 1DAY
STARTS CURDATE() +INTERVAL 5DAY
ENDS CURDATE() +INTERVAL 1MONTH