1、查看Events是否开启
select @@event_scheduler;
show variables like 'event_scheduler';
2、开启Events方法
set GLOBAL event_scheduler=ON;
或
set GLOBAL event_scheduler=1;
3、创建存储过程
CREATE PROCEDURE del_table()
BEGIN
delete from table where xxx;
END
4、创建定时事件
//从2019-02-01 00:00:00开始,每一天执行一次
create event if not exists e_deleteData
on schedule every 1 day STARTS '2019-02-01 00:00:00'
on completion preserve
do call del_table();
5、启动定时事件
ALTER EVENT e_deleteData ON COMPLETION PRESERVE ENABLE;