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.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-events-table/