SHOW CREATE EVENT

Syntax

SHOW CREATE EVENT event_name

Description

This statement displays the CREATE EVENT statement that creates a given event, as well as the SQL_MODE that was used when the trigger was created, and the character set used by the connection. To find out which events are present, use SHOW EVENTS.

Current

SHOW CREATE EVENT quotes identifiers according to the value of the sql_quote_show_create system variable.

< 10.6.5 / 10.5.13 / 10.4.22

SHOW CREATE EVENT quotes identifiers according to the value of the sql_quote_show_create system variable. Note, however, that the output of this statement is unreliably affected by the sql_quote_show_create system variable.

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

See also

• Events Overview

• CREATE EVENT

• ALTER EVENT

• DROP EVENT

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}