# mysql.event Table

The `mysql.event` table contains information about MariaDB [events](https://mariadb.com/docs/server/server-usage/triggers-events/event-scheduler). Similar information can be obtained by viewing the [INFORMATION\_SCHEMA.EVENTS](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-events-table) table, or with the [SHOW EVENTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events) and [SHOW CREATE EVENT](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event) statements.

The table is upgraded live, and there is no need to restart the server if the table has changed.

This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine.

The `mysql.event` table contains the following fields:

<table><thead><tr><th>Field</th><th>Type</th><th width="128">Null</th><th>Key</th><th>Default</th><th>Description</th></tr></thead><tbody><tr><td>db</td><td>char(64)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>name</td><td>char(64)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>body</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td></tr><tr><td>definer</td><td>char(141)</td><td>NO</td><td></td><td></td><td></td></tr><tr><td>execute_at</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>interval_value</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>interval_field</td><td>enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>created</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td></td></tr><tr><td>modified</td><td>timestamp</td><td>NO</td><td></td><td>0000-00-00 00:00:00</td><td></td></tr><tr><td>last_executed</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>starts</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>ends</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>status</td><td>enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')</td><td>NO</td><td></td><td>ENABLED</td><td>Current status of the event, one of enabled, disabled, or disabled on the slaveside.</td></tr><tr><td>on_completion</td><td>enum('DROP','PRESERVE')</td><td>NO</td><td></td><td>DROP</td><td></td></tr><tr><td>sql_mode</td><td>set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')</td><td>NO</td><td></td><td></td><td>The <a href="../../../server-management/variables-and-modes/sql_mode">SQL_MODE</a> at the time the event was created.</td></tr><tr><td>comment</td><td>char(64)</td><td>NO</td><td></td><td></td><td></td></tr><tr><td>originator</td><td>int(10) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr><tr><td>time_zone</td><td>char(64)</td><td>NO</td><td></td><td>SYSTEM</td><td></td></tr><tr><td>character_set_client</td><td>char(32)</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>collation_connection</td><td>char(32)</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>db_collation</td><td>char(32)</td><td>YES</td><td></td><td>NULL</td><td></td></tr><tr><td>body_utf8</td><td>longblob</td><td>YES</td><td></td><td>NULL</td><td></td></tr></tbody></table>

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}