mysql event事件

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 BEGINsql语句    END$$DELIMITER ;

4、显示事件信息   SHOW EVENTS LIKE 'deleteTwoDayBefore';