7.mysql定时删除60天前的数据

1.查看even_schedule是否开启，如果没开启，使用下面命令开启，阿里云服务器需要在管理后台开启 SET GLOBAL event_scheduler=ON;   2.创建PROCEDURE存储过程 DROP PROCEDURE IF EXISTS KeepMessageDatasWith60Days;   CREATE PROCEDURE KeepMessageDatasWith60Days() BEGIN SET @cou =(SELECT COUNT(1) FROM message WHERE createTime < DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 60 DAY),'%Y%m%d')); WHILE @cou>0 DO DELETE FROM message WHERE createTime<date_format(date_sub(now(),interval 60="" day),'%y%m%d')="" limit="" 100000;="" <="" div=""> END WHILE; END;    3.创建event定时任务 DROP EVENT IF EXISTS KeepMessageDatasWith60Days;   CREATE EVENT KeepMessageDatasWith60Days ON SCHEDULE EVERY 2 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY),INTERVAL 2 MONTH),INTERVAL 1 HOUR) #每两个月的第一天凌晨1点执行 ON COMPLETION PRESERVE DISABLE DO CALL KeepMessageDatasWith60Days();   ALTER EVENT KeepMessageDatasWith60Days ON COMPLETION PRESERVE ENABLE;