mysql event

system version
mysql ver 14.14 distrib 5.7.26

---

目录

1.check event status is on

2.set event status

3.view event

4.start event

5.stop event

6.create event

7.alter event

8.drop event

9.test event 

---

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