mysql5.7删除90天以前的数据

-- https://www.runoob.com/w3cnote/mysql-stored-procedure.html
-- 开启事件
SET GLOBAL event_scheduler = 1;  
SET @@global.event_scheduler = 1;  
SET GLOBAL event_scheduler = ON;  
SET @@global.event_scheduler = ON;
-- 创建存储过程
CREATE PROCEDURE `prc_del_alarm`(IN date_inter int) COMMENT '自动删除告警'
BEGIN
delete from yd_alarminfo where (TO_DAYS(NOW()) - TO_DAYS(eventTime))>=date_inter;
END
-- 创建事件，调度。每天执行一次
CREATE EVENT `auto_delete_alarm` ON SCHEDULE EVERY 1 DAY STARTS '2020-06-08 11:00:00'
ON COMPLETION PRESERVE ENABLE COMMENT '自动删除90天以前的告警数据' 
DO call prc_del_alarm(90);



-- 手动执行存储过程
call prc_del_alarm(90);



SHOW VARIABLES LIKE 'event_scheduler';
SELECT @@event_scheduler;
SHOW PROCESSLIST;

-- 查看库下的存储过程，两个都可以
select name from mysql.proc where db='test01';
show procedure status where db='test01';


-- 查看事件
SHOW EVENTS
-- 删除事件
DROP EVENTS IF EXISTS updateInfoStatus
-- 临时关闭事件
ALTER EVENTS updateInfoStatus DISABLE
-- 开启事件
ALTER EVENTS updateInfoStatus ENABLE