mysql开启定时器定时删除之前的数据

create procedure pro()
  BEGIN
DELETE from lgv_current_infos WHERE time < date_sub(CURDATE(), interval 1 day); // 前一天
  end;

create event if not exists eventJob 
  on schedule every 10 second 
  on completion PRESERVE
  do call pro();

SET GLOBAL event_scheduler = 1;//开启定时器

SET GLOBAL event_scheduler = 0;//停止定时器

ALTER EVENT eventJob ON  COMPLETION PRESERVE ENABLE;//开启事件

ALTER EVENT eventJob ON COMPLETION PRESERVE DISABLE;//关闭事件

SHOW VARIABLES LIKE '%sche%';//查看定时器状态

 

参考博客mysql 使用定时器执行任务