1.查看event是否开启
show variables like '%sche%';
2.将事件计划开启
set global event_scheduler =1;
或
SET GLOBAL event_scheduler = ON;
3.例子
一.12点整执行accountall()函数:
CREATE EVENT test
ON SCHEDULE AT TIMESTAMP '2019-07-02 10:10:00'
DO CALL accountall(NOW());
二.5天后清空test表
CREATE EVENT e_test
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 5 DAY
DO TRUNCATETABLE test.aaa;
三.每天定时清空test表
CREATE EVENT e_test
ON SCHEDULE EVERY 1 DAY
DO TRUNCATETABLE test.aaa;
四.每天定时清空test表,5天后停止执行
CREATE EVENT e_test
ONS CHEDULE EVERY 1 DAY
ENDS CURRENT_TIMESTAMP+ INTERVAL 5 DAY
DO TRUNCATETABLE test.aaa;
五. 5天后开启每天定时清空test表
CREATE EVENT e_test
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_TIMESTAMP+ INTERVAL 5 DAY
DO TRUNCATETABLE test.aaa;
六。每小时执行一次,12点开始准点执行
CREATE EVENT stars
ON SCHEDULE EVERY 1 HOUR
STARTS '2019-07-03 12:00:00'
DO CALL star_ranks();
4.、删除事件
DROP EVENT e_test;