Rechercher dans le manuel MySQL

13.7.6.18 SHOW EVENTS Syntax

Inhaltsverzeichnis
  1. SHOW EVENTS
  2.     [{FROM | IN} schema_name]
  3.     [LIKE 'pattern' | WHERE expr]

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:

  1. mysql> SELECT CURRENT_USER(), SCHEMA();
  2. +----------------+----------+
  3. | CURRENT_USER() | SCHEMA() |
  4. +----------------+----------+
  5. | jon@ghidora    | myschema |
  6. +----------------+----------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> SHOW EVENTS\G
  10. *************************** 1. row ***************************
  11.                   Db: myschema
  12.                 Name: e_daily
  13.              Definer: jon@ghidora
  14.            Time zone: SYSTEM
  15.                 Type: RECURRING
  16.           Execute at: NULL
  17.       Interval value: 1
  18.       Interval field: DAY
  19.               Starts: 2018-08-08 11:06:34
  20.                 Ends: NULL
  21.               Status: ENABLED
  22.           Originator: 1
  23. character_set_client: utf8mb4
  24. collation_connection: utf8mb4_0900_ai_ci
  25.   Database Collation: 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:

  1. 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 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 'user_name'@'host_name' format.

  • 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) or RECURRING (repeating).

  • Execute At

    For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an event is created using ON 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 an EVERY clause instead of an AT clause (that is, if the event is recurring), the value of this column is NULL.

  • 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 is NULL if no start date and time are defined for the event. For a transient event, this column is always NULL. For a recurring event whose definition includes a STARTS clause, this column contains the corresponding DATETIME value. As with the Execute At column, this value resolves any expressions used. If there is no STARTS clause affecting the timing of the event, this column is NULL

  • Ends

    For a recurring event whose definition includes a ENDS clause, this column contains the corresponding DATETIME value. As with the Execute At column, this value resolves any expressions used. If there is no ENDS clause affecting the timing of the event, this column is NULL.

  • Status

    The event status. One of ENABLED, DISABLED, or SLAVESIDE_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.


Suchen Sie im MySQL-Handbuch

Deutsche Übersetzung

Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.

Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.

Vielen Dank im Voraus.

Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-show-events.html

Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.

Referenzen

  1. Zeigen Sie - html-Dokument Sprache des Dokuments:en Manuel MySQL : https://dev.mysql.com/

Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.

Inhaltsverzeichnis Haut