system version
mysql ver 14.14 distrib 5.7.26
目录
1.check event status is on
show variables like 'event_scheduler';
OR
show processlist;
OR
select @@event_scheduler;
2.set event status
- open event
set global event_scheduler = ON
OR
set global event_scheduler = 1
- close event
set global event_scheduler = OFF
OR
set global event_scheduler = 0
3.view event
show events;
OR
select * from information_schema.events;
4.start event
alter event eventname on completion preserve enable;
5.stop event
alter event eventname on completion preserve disable;
6.create event
- expression