SHOW EVENTS
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.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.