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;