EVENTS

The EVENTS view contains details about Event Manager events.

Column name	Description
EVENT_CATALOG	The catalog to which the event belongs. This value is always def.
EVENT_SCHEMA	The schema (database) to which the event belongs.
EVENT_NAME	The name of the event.
DEFINER	The account listed in the DEFINER clause, typically the user who created the event, in 'user_name'@'host_name' format.
TIME_ZONE	The time zone used for scheduling and execution of the event. The default value is SYSTEM.
EVENT_BODY	The language used for statements in the event’s DO clause. Always SQL.
EVENT_DEFINITION	The SQL statement that the event executes in the DO clause.
EVENT_TYPE	The event repetition type: ONE TIME for transient events, RECURRING for repeating events.
EXECUTE_AT	For one-time events, the DATETIME value from the AT clause, adjusted by any interval. NULL for recurring events.
INTERVAL_VALUE	The number of intervals between executions for recurring events. NULL for transient events.
INTERVAL_FIELD	The time unit used for the interval of recurring events. NULL for transient events.
SQL_MODE	The SQL mode in effect when the event was created or modified.
STARTS	The DATETIME when the event starts for recurring events. NULL if not defined.
ENDS	The DATETIME when the event ends for recurring events. NULL if not defined.
STATUS	The event’s status: ENABLED, DISABLED, or REPLICA_SIDE_DISABLED (previously SLAVESIDE_DISABLED).
ON_COMPLETION	Indicates whether the event is preserved or not: PRESERVE or NOT PRESERVE.
CREATED	The TIMESTAMP when the event was created.
LAST_ALTERED	The TIMESTAMP when the event was last modified.
LAST_EXECUTED	The DATETIME when the event was last executed. NULL if it has never been executed.
EVENT_COMMENT	The comment associated with the event. Empty if none.
ORIGINATOR	The ID of the server where the event was created, used in replication. The default value is 0.
CHARACTER_SET_CLIENT	The session value of character_set_client when the event was created.
COLLATION_CONNECTION	The session value of collation_connection when the event was created.
DATABASE_COLLATION	The collation of the database associated with the event.

Note

EVENTS is a nonstandard INFORMATION_SCHEMA view.

Times in the EVENTS view are displayed using the event time zone, the current session time zone, or UTC.

For more information, see the MySQL documentation: The INFORMATION_SCHEMA EVENTS Table.