Mysql event viewing and timer related operations

Mysql event viewing and timer related operations view event SHOW EVENTSselect * from mysql. event to check whether the show variables like 'event _ scheduler 'timer is enabled; enable the timer 0: off 1: onSET GLOBAL event_scheduler = 1 ;. delete drop EVENT * _ event; create event if not exists * _ event_testON SCHEDULE every 1 HourDO CALL update _ * _ proc (); or create event if not exists update _ * _ eventON SCHEDULE every 1 day starts timestamp (CURRENT_DATE, '00: 05: 00 ') on completion preserve enabledo call update _ * _ proc (); date_add (date (curdate () + 1), interval 8 hour)