SHOW EVENTS
[{FROM | IN} schema_name]
[LIKE 'pattern' | WHERE expr]
This statement displays information about Event Manager events,
which are discussed in Section 23.4, “Using the Event Scheduler”. It
requires the EVENT
privilege for
the database from which the events are to be shown.
In its simplest form, SHOW EVENTS
lists all of the events in the current schema:
mysql> SELECT CURRENT_USER(), SCHEMA();
+----------------+----------+
| CURRENT_USER() | SCHEMA() |
+----------------+----------+
| jon@ghidora | myschema |
+----------------+----------+
1 row in set (0.00 sec)
mysql> SHOW EVENTS\G
*************************** 1. row ***************************
Db: myschema
Name: e_daily
Definer: jon@ghidora
Time zone: SYSTEM
Type: RECURRING
Execute at: NULL
Interval value: 1
Interval field: DAY
Starts: 2018-08-08 11:06:34
Ends: NULL
Status: ENABLED
Originator: 1
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
To see events for a specific schema, use the
FROM
clause. For example, to see events for
the test
schema, use the following statement:
SHOW EVENTS FROM test;
The LIKE
clause, if present,
indicates which event names to match. The
WHERE
clause can be given to select rows
using more general conditions, as discussed in
Section 24.8, “Extensions to SHOW Statements”.
SHOW EVENTS
output has these
columns:
Db
The name of the schema (database) to which the event belongs.
Name
The name of the event.
Definer
The account of the user who created the event, in
'
format.user_name
'@'host_name
'Time zone
The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. The default value is
SYSTEM
.Type
The event repetition type, either
ONE TIME
(transient) orRECURRING
(repeating).Execute At
For a one-time event, this is the
DATETIME
value specified in theAT
clause of theCREATE EVENT
statement used to create the event, or of the lastALTER EVENT
statement that modified the event. The value shown in this column reflects the addition or subtraction of anyINTERVAL
value included in the event'sAT
clause. For example, if an event is created usingON SCHEDULE AT CURRENT_TIMESTAMP + '1:6' DAY_HOUR
, and the event was created at 2018-02-09 14:05:30, the value shown in this column would be'2018-02-10 20:05:30'
. If the event's timing is determined by anEVERY
clause instead of anAT
clause (that is, if the event is recurring), the value of this column isNULL
.Interval Value
For a recurring event, the number of intervals to wait between event executions. For a transient event, the value of this column is always
NULL
.Interval Field
The time units used for the interval which a recurring event waits before repeating. For a transient event, the value of this column is always
NULL
.Starts
The start date and time for a recurring event. This is displayed as a
DATETIME
value, and isNULL
if no start date and time are defined for the event. For a transient event, this column is alwaysNULL
. For a recurring event whose definition includes aSTARTS
clause, this column contains the correspondingDATETIME
value. As with theExecute At
column, this value resolves any expressions used. If there is noSTARTS
clause affecting the timing of the event, this column isNULL
Ends
For a recurring event whose definition includes a
ENDS
clause, this column contains the correspondingDATETIME
value. As with theExecute At
column, this value resolves any expressions used. If there is noENDS
clause affecting the timing of the event, this column isNULL
.Status
The event status. One of
ENABLED
,DISABLED
, orSLAVESIDE_DISABLED
.SLAVESIDE_DISABLED
indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on the replica. For more information, see Section 16.4.1.16, “Replication of Invoked Features”. information.Originator
The server ID of the MySQL server on which the event was created; used in replication. This value may be updated by
ALTER EVENT
to the server ID of the server on which that statement occurs, if executed on a source server. The default value is 0.character_set_client
The session value of the
character_set_client
system variable when the event was created.collation_connection
The session value of the
collation_connection
system variable when the event was created.Database Collation
The collation of the database with which the event is associated.
For more information about SLAVESIDE_DISABLED
and the Originator
column, see
Section 16.4.1.16, “Replication of Invoked Features”.
Times displayed by SHOW EVENTS
are given in the event time zone, as discussed in
Section 23.4.4, “Event Metadata”.
Event information is also available from the
INFORMATION_SCHEMA
EVENTS
table. See
Section 24.3.8, “The INFORMATION_SCHEMA EVENTS Table”.
The event action statement is not shown in the output of
SHOW EVENTS
. Use
SHOW CREATE EVENT
or the
INFORMATION_SCHEMA
EVENTS
table.