MySQL Event opening and invocation

Detects if an event is turned on

Show variables like ' Event_scheduler ';

Turn on Events

Set global Event_scheduler = on;

create a stored procedure

Delimiter//create procedure test () beginupdate Test fdcreate = Now (); end;

Create an event

Create event if not exists E_teston schedule every the Secondon completion Preservedo call Test ();

turn off or turn on execution events

Alter event event_name on completion preserve [enable | disable]

Delete Event

Drop event event_name;

MySQL Event opening and invocation