一、检查event事件是否开启(ON为开启/OFF为未开启)
SHOW VARIABLES LIKE 'event_scheduler';
二、开启event事件
set GLOBAL event_scheduler=ON;
三、 创建定时任务(my_event=定时任务名称)
CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
delete from test where create_time < NOW() - INTERVAL 1 DAY;
四、 修改定时任务(my_event=定时任务名称)
ALTER EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO delete from test where create_time < NOW() - INTERVAL 1 DAY;
五、查看定时任务
SHOW EVENTS
六、 查看定时任务详细信息(my_event=定时任务名称)
SHOW CREATE EVENT my_event
七、查看定时任务执行情况
SELECT * FROM information_schema.EVENTS;
八、删除定时任务
DROP EVENT my_event