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.
© 2019 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/