Syntax
------ 
SHOW EVENTS [{FROM | IN} schema_name]
 [LIKE 'pattern' | WHERE expr]
 
Description
----------- 
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:
 
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
 
To see the event action, use SHOW CREATE EVENT instead, or
look at the information_schema.EVENTS 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:
 
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 Extended Show.
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-events/