//创建清理日志存储过程
use iot_device_log;
create procedure del_log()
begin
delete from device_log where create_date < from_unixtime(unix_timestamp(now()) - 2*30*24*60*60);
end;
//创建定时调用清理日志的事件
--每天凌晨1点执行
create event del_log_event
on schedule every 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 1 HOUR)
do call del_log();
查看定时任务
SELECT event_name,event_definition,interval_value,interval_field,status FROM information_schema.EVENTS;
11-13
1600
10-21
1560
10-14
584