Mysql Timer Event Learning notes _mysql

The constant global event_scheduler of MySQL must be on or 1 for the timer to function.

--See if the timer is turned on
Show VARIABLES like '%sche% ';

--Open Timer 0:off 1:on
SET GLOBAL event_scheduler = 1;

--Create Event
--Automatically calls the e_test () stored procedure every second
CREATE EVENT IF not EXISTS event_test
On SCHEDULE EVERY 1 SECOND
On completion PRESERVE
Do call E_test ();

--Open Event
ALTER EVENT event_test on
Completion PRESERVE ENABLE;

--Shutdown Event
ALTER EVENT event_test on
Completion PRESERVE DISABLE;

SELECT * from T;