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语句。