通过MySQL事件实现定时操作

1.首先查看MySQL event事件是否开启

执行SQL语句如下：

show variables like '%sche%';

查看event_scheduler是否为ON，如果不是，执行如下SQL语句开启：

set global event_scheduler = 1;

2.创建事件执行任务

执行SQL语句如下：

DELIMITER |
DROP event IF EXISTS deleteData;
CREATE EVENT deleteData  
    ON SCHEDULE EVERY 1 DAY STARTS '2018-05-09 23:50:00'  
DO
BEGIN  
    delete from student where DATEDIFF(NOW(),study_time)>60;
    delete from teacher where DATEDIFF(NOW(),work_time)>60;
END |
DELIMITER;

在begin和end之间输入你需要定时执行的SQL语句。