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:
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.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-events/