1、查看event 事件是否开启 SHOW VARIABLES LIKE 'event_scheduler';
2、开启event 事件 set global event_scheduler=on;
3、创建 事件 (每天定点执行)
DELIMITER $$
creat EVENT `deleteTwoDayBefore` ON SCHEDULE EVERY 1 DAY STARTS '2018-04-09 00:00:00' ON COMPLETION NOT PRESERVE ENABLE
DO BEGIN
sql语句
END$$
DELIMITER ;
4、显示事件信息 SHOW EVENTS LIKE 'deleteTwoDayBefore';