Information Schema EVENTS Table

You are viewing an old version of this article. View the current version here.

The Information Schema EVENTS table stores information about Events on the server.

It contains the following columns:

ColumnDescription
EVENT_CATALOGAlways def.
EVENT_SCHEMADatabase where the event was defined.
EVENT_NAMEEvent name.
DEFINEREvent definer.
TIME_ZONETime zone used for the event's scheduling and execution, by default SYSTEM.
EVENT_BODYSQL.
EVENT_DEFINITIONThe SQL defining the event.
EVENT_TYPEEither ONE TIME or RECURRING.
EXECUTE_ATDATETIME when the event is set to execute, or NULL if recurring.
INTERVAL_VALUENumeric interval between event executions for a recurring event, or NULL if not recurring.
INTERVAL_FIELDInterval unit (e.g., HOUR)
SQL_MODEThe SQL_MODE at the time the event was created.
STARTSStart DATETIME for a recurring event, NULL if not defined or not recurring.
ENDSEnd DATETIME for a recurring event, NULL if not defined or not recurring.
STATUSOne of ENABLED, DISABLED or /SLAVESIDE_DISABLED.
ON_COMPLETIONThe ON COMPLETION clause, either PRESERVE or NOT PRESERVE .
CREATEDWhen the event was created.
LAST_ALTEREDWhen the event was last changed.
LAST_EXECUTEDWhen the event was last run.
EVENT_COMMENTThe comment provided in the CREATE EVENT statement, or an empty string if none.
ORIGINATORMariaDB server ID on which the event was created.
CHARACTER_SET_CLIENTcharacter_set_client system variable session value at the time the event was created.
COLLATION_CONNECTIONcollation_connection system variable session value at the time the event was created.
DATABASE_COLLATIONDatabase collation with which the event is linked.

The SHOW EVENTS and SHOW CREATE EVENT statements provide similar information.

Comments

Comments loading...
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.