mysql可以创建任务并设定执行时间及频率
1)每秒插入一条记录到数据表
CREATE EVENT e_test_insert
ON SCHEDULE EVERY 1 SECOND
DO INSERT INTO test.aaa VALUES (数据);
2)每天定时清空test表:
CREATE EVENT e_test
ON SCHEDULE EVERY 1 DAY
starts TIMESTAMP ‘2011-07-08 12:00:00’
DO TRUNCATE TABLE test.aaa;
3) 每天定时清空test表,5天后停止执行:
CREATE EVENT e_test
ON SCHEDULE EVERY 1 DAY
ENDS CURRENT_TIMESTAMP + INTERVAL 5 DAY
DO TRUNCATE TABLE test.aaa;
4) 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 test.aaa;
注:‘test.aaa’表示操作对象为test数据库aaa表
‘SCHEDULE EVERY’表示时间间隔
‘starts’表示事件开始时间
‘ENDS’表示事件结束时间
‘DO’其后面为要执行的sql语句