Mysql定位清理数据

首先先查看mysql是否开启定时任务开关

# SHOW VARIABLES LIKE 'event_scheduler';

Value为ON则已打开，OFF则关闭

如果是OFF，就先打开：

# SET GLOBAL event_scheduler = ON;

DELIMITER $$  
DROP EVENT IF EXISTS deletedata;  
CREATE EVENT  deletedata  
ON SCHEDULE EVERY 1 DAY  
ON COMPLETION PRESERVE  
DO BEGIN  
  delete from iot_data_2 where TO_DAYS(now())-TO_DAYS(created_at)>1;  
END$$  
DELIMITER ; 

创建完成后，查看定时器

# select * from mysql.event;