/* *创建存储过程 * */ CREATE PROCEDURE if not exists test() BEGIN insert into test.test (time) VALUES( curdate() ); END; set GLOBAL event_scheduler=0; //设置任务器 开关 1开 0关 show VARIABLES like 'event_scheduler'; //查看任务器 //创建定时任务 create event if not exists event_test on SCHEDULE EVERY 30 SECOND //设置任务运行间隔时间 do call test(); //调用存储过程 schedule: //在某个时间点(+间隔时间) AT TIMESTAMP [+ INTERVAL INTERVAL] | EVERY INTERVAL [STARTS TIMESTAMP] [ENDS TIMESTAMP] //间隔时间执行 INTERVAL: quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE | WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE | DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND} 1) 每秒插入一条记录到数据表 1 USE test; 2 CREATETABLE aaa (timeline TIMESTAMP); 3 CREATEEVENT e_test_insert 4 ONSCHEDULE EVERY 1 SECOND 5 DO INSERTINTO test.aaa VALUES(CURRENT_TIMESTAMP); 2) 5天后清空test表: 1 CREATE EVENT e_test 2 ONSCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 5 DAY 3 DO TRUNCATETABLE test.aaa; 3) 2007年7月20日12点整清空test表: 1 CREATE EVENT e_test 2 ONSCHEDULE AT TIMESTAMP '2007-07-20 12:00:00' 3 DO TRUNCATETABLE test.aaa; 4) 每天定时清空test表: 1 CREATE EVENT e_test 2 ONSCHEDULE EVERY 1 DAY 3 DO TRUNCATETABLE test.aaa;
mysql存储过程 计划任务_mysql 存储过程+定时任务
最新推荐文章于 2023-06-08 21:33:26 发布