mysql定时任务每天凌晨删除一周前数据

1、查看数据库是否开启定时调度

SHOW VARIABLES LIKE 'event_scheduler';//查看OFF为关
SET GLOBAL event_scheduler = ON;//设置开启，重启后失效

防止重启后失效

设置my.cnf，Linux一般在/etc/my.cnf ，

在[mysqld]下增加
event_scheduler = ON //重启后生效

 

2、执行命令

DROP event IF EXISTS e_delete_channel;
CREATE EVENT e_delete_channel
ON SCHEDULE
EVERY 1 DAY STARTS '2020-10-30 00:00:00'
DO
DELETE FROM t_instant_channel WHERE occurtime < DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 7 DAY);