Rechercher dans le manuel MySQL
13.7.6.18 SHOW EVENTS Syntax
This statement displays information about Event Manager events,
which are discussed in Section 24.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:
- +----------------+----------+
- +----------------+----------+
- | jon@ghidora | myschema |
- +----------------+----------+
- mysql> SHOW EVENTS\G
- *************************** 1. row ***************************
- Db: myschema
- Name: e_daily
- Definer: jon@ghidora
- Time zone: SYSTEM
- Type: RECURRING
- Execute at: NULL
- Starts: 2018-08-08 11:06:34
- Ends: NULL
- Status: ENABLED
- Originator: 1
- character_set_client: utf8mb4
- collation_connection: utf8mb4_0900_ai_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:
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 25.42, “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 master and replicated to the current MySQL server which is acting as a slave, but the event is not presently being executed on the slave. For more information, see Section 17.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 master 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 17.4.1.16, “Replication of Invoked Features”.
Times displayed by SHOW EVENTS
are given in the event time zone, as discussed in
Section 24.4.4, “Event Metadata”.
Event information is also available from the
INFORMATION_SCHEMA
EVENTS
table. See
Section 25.10, “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.
Nederlandse vertaling
U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.
Bij voorbaat dank.
Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-show-events.html
De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.
Referenties
Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.