Mysql event enabling and calling, mysql event calling

Mysql event enabling and calling, mysql event calling

Check whether the event is enabled

Copy codeThe Code is as follows:
Show variables like 'event _ schedount ';

2. Enable event

Copy codeThe Code is as follows:
Set global event_scheduler = on;

3. Create a stored procedure

Copy codeThe Code is as follows:
Delimiter //
Create procedure test ()
Begin
Update project set create_time = now ();
End;

4. Create an event

Copy codeThe Code is as follows:
Create event if not exists e_test
On schedule every 30 second
On completion preserve
Do call test ();

5. Close or enable the execution event

Copy codeThe Code is as follows:
Alter event event_name on completion preserver [enable | disable]

6. delete an event

Copy codeThe Code is as follows:
Drop event event_name;