SQL: How to alter the Event in MySQL DB

Description

To alter an even in MySQL you can first list all the events using following command  i.e. show events from TestTable;


Syntax Than after getting the list 
    

ALTER EVENT EmpDataEvent

   ON SCHEDULE EVERY 1 hour

   DO

 INSERT INTO job_example  VALUES (1,'prateek');

and it is now done.

ALTER EVENT EventTransactionValue

ON SCHEDULE EVERY 1 DAY  STARTS '2017-11-28 23:30:00'

DO

CALL `Fetch_GET_EventTransactionValue`;

SET GLOBAL event_scheduler = ON;