Movatterモバイル変換

SHOW CREATE EVENTevent_name

This statement displays theCREATE EVENT statement needed to re-create a given event. It requires theEVENT privilege for the database from which the event is to be shown. For example (using the same evente_daily defined and then altered inSection 15.7.7.20, “SHOW EVENTS Statement”):

mysql> SHOW CREATE EVENT myschema.e_daily\G*************************** 1. row ***************************               Event: e_daily            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,                      NO_ZERO_IN_DATE,NO_ZERO_DATE,                      ERROR_FOR_DIVISION_BY_ZERO,                      NO_ENGINE_SUBSTITUTION           time_zone: SYSTEM        Create Event: CREATE DEFINER=`jon`@`ghidora` EVENT `e_daily`                        ON SCHEDULE EVERY 1 DAY                        STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR                        ON COMPLETION NOT PRESERVE                        ENABLE                        COMMENT 'Saves total number of sessions then                                clears the table each day'                        DO BEGIN                          INSERT INTO site_activity.totals (time, total)                            SELECT CURRENT_TIMESTAMP, COUNT(*)                              FROM site_activity.sessions;                          DELETE FROM site_activity.sessions;                        ENDcharacter_set_client: utf8mb4collation_connection: utf8mb4_0900_ai_ci  Database Collation: utf8mb4_0900_ai_ci

character_set_client is the session value of thecharacter_set_client system variable when the event was created.collation_connection is the session value of thecollation_connection system variable when the event was created.Database Collation is the collation of the database with which the event is associated.

The output reflects the current status of the event (ENABLE) rather than the status with which it was created.