SHOW CREATE EVENT

SHOW CREATE EVENT event_name

The SHOW CREATE EVENT statement returns the CREATE EVENT statement that would recreate the specified event. To use this statement, you must have the EVENT privilege on the database that contains the event.

The output reflects the event’s current definition, including its status (for example, ENABLE or DISABLE).

For more information, see the MySQL documentation: SHOW CREATE EVENT Statement.