MySql Create Event Wizard

CREATE ALTER DROP RENAME


Generate Code

Tips

don't forget to enable events,
SET GLOBAL event_scheduler = ON;

change my.cnf file to make it persistent,
be sure it should under [mysqld]
event_scheduler=ON

is event_scheduler enabled?
SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler'

you can list events on database,
show events where name='myEventName';
or
select * from mysql.event where name='myEventName';

useful links,
mysql reference: create event
mysql reference: alter event