Syntax
------ 
SHOW CREATE EVENT event_name
 
Description
----------- 
This statement displays the CREATE EVENT
statement needed to re-create a given event, as well as the
SQL_MODE that was used when the trigger has been created and
the character set used by the connection.. To find out which
events are present, use SHOW EVENTS.
 
The output of this statement is unreliably affected by the
sql_quote_show_create server system variable - see
http://bugs.mysql.com/bug.php?id=12719
 
The information_schema.EVENTS table provides similar, but
more complete, information.
 
Examples
-------- 
SHOW CREATE EVENT test.e_daily\G
*************************** 1. row
***************************
 Event: e_daily
 sql_mode: 
 time_zone: SYSTEM
 Create Event: CREATE EVENT `e_daily`
 ON SCHEDULE EVERY 1 DAY
 STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR
 ON COMPLETION NOT PRESERVE
 ENABLE
 COMMENT 'Saves total number of sessions then
 clears the table each day'
 DO BEGIN
 INSERT INTO site_activity.totals (time, total)
 SELECT CURRENT_TIMESTAMP, COUNT(*) 
 FROM site_activity.sessions;
 DELETE FROM site_activity.sessions;
 END
character_set_client: latin1
collation_connection: latin1_swedish_ci
 Database Collation: latin1_swedish_ci
 


URL: https://mariadb.com/kb/en/show-create-event/