Information Schema EVENTS Table
The Information Schema EVENTS
table stores information about Events on the server.
It contains the following columns:
Column
Description
EVENT_CATALOG
Always def.
EVENT_SCHEMA
Database where the event was defined.
EVENT_NAME
Event name.
DEFINER
Event definer.
TIME_ZONE
Time zone used for the event's scheduling and execution, by default SYSTEM.
EVENT_BODY
SQL.
EVENT_DEFINITION
The SQL defining the event.
EVENT_TYPE
Either ONE TIME or RECURRING.
EXECUTE_AT
DATETIME when the event is set to execute, or NULL if recurring.
INTERVAL_VALUE
Numeric interval between event executions for a recurring event, or NULL if not recurring.
INTERVAL_FIELD
Interval unit (e.g., HOUR)
SQL_MODE
The SQL_MODE at the time the event was created.
STARTS
Start DATETIME for a recurring event, NULL if not defined or not recurring.
ENDS
End DATETIME for a recurring event, NULL if not defined or not recurring.
STATUS
One of ENABLED, DISABLED or /SLAVESIDE_DISABLED.
ON_COMPLETION
The ON COMPLETION clause, either PRESERVE or NOT PRESERVE .
CREATED
When the event was created.
LAST_ALTERED
When the event was last changed.
LAST_EXECUTED
When the event was last run.
EVENT_COMMENT
The comment provided in the CREATE EVENT statement, or an empty string if none.
ORIGINATOR
MariaDB server ID on which the event was created.
CHARACTER_SET_CLIENT
character_set_client system variable session value at the time the event was created.
COLLATION_CONNECTION
collation_connection system variable session value at the time the event was created.
DATABASE_COLLATION
Database collation with which the event is linked.
The SHOW EVENTS and SHOW CREATE EVENT statements provide similar information.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?