List scheduled events. View metadata such as the event name, schedule, status, and timing for events in a database.
SHOW EVENTS [{FROM | IN} schema_name]
[LIKE 'pattern' | WHERE expr]Shows information about Event Manager events (created with CREATE EVENT). Requires the EVENT privilege. Without any arguments, SHOW EVENTS lists all of the events in the current schema:
To see the event action, use instead, or look at the table.
To see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:
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 .
This page is licensed: GPLv2, originally from
SHOW EVENTS FROM test;SELECT CURRENT_USER(), SCHEMA();
+----------------+----------+
| CURRENT_USER() | SCHEMA() |
+----------------+----------+
| jon@ghidora | myschema |
+----------------+----------+
SHOW EVENTS\G
*************************** 1. row ***************************
Db: myschema
Name: e_daily
Definer: jon@ghidora
Time zone: SYSTEM
Type: RECURRING
Execute at: NULL
Interval value: 10
Interval field: SECOND
Starts: 2006-02-09 10:41:23
Ends: NULL
Status: ENABLED
Originator: 0
character_set_client: latin1
collation_connection: latin1_swedish_ci
Database Collation: latin1_swedish_ci