information_schema.events.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
events |
||||||||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
created |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
ends |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_body |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_comment |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_definition |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
execute_at |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
interval_field |
ENUM NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
interval_value |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
last_altered |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
last_executed |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
on_completion |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
originator |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
starts |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
status |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
time_zone |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||