首先先查看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;