mysql事件

//查看事件是否开启 show variables like ‘event_scheduler’;

//设置事件开启 set global event_scheduler=on;

//查看所有事件 show events;

//每天2018-04-19 09:22:00开始删除users表 DROP event IF EXISTS e_totals; CREATE EVENT e_totals ON SCHEDULE EVERY 1 DAY STARTS ‘2018-04-19 09:22:00’ DO delete from users;

//查看数据中的event事件(数据库名) show events from mybaits\G;

//查看event事件内容(事件名称) show create event e_totals\G;