MYSQL定时任务

创建存储过程:

CREATE PROCEDURE interval_wechat_rep_log()
BEGIN
    insert into t_wechat_rep_log_bak select * from t_wechat_rep_log where createDate  < DATE_SUB(CURDATE(), INTERVAL 6 MONTH);
    delete from t_wechat_rep_log where createDate  < DATE_SUB(CURDATE(), INTERVAL 6 MONTH);
END

每月执行存储过程(带下划线的是自己定义的):

create event event_wechat_rep_log
on schedule every 1 MONTH 
do call interval_wechat_rep_log();