SHOW CREATE EVENT语句
SHOW CREATE EVENT event_name
该语句显示CREATE EVENT
重新创建给定事件所需的语句。它要求EVENT
显示事件的数据库具有特权。例如(使用相同的事件e_daily
,然后在“ SHOW EVENTS语句”中定义并更改):
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; END character_set_client : utf8mb4 collation_connection : utf8mb4_0900_ai_ci Database Collation : utf8mb4_0900_ai_ci
character_set_client
是character_set_client
创建事件时系统变量的会话值。collation_connection
是collation_connection
创建事件时系统变量的会话值。Database Collation
是与事件关联的数据库的整理。
输出反映事件(ENABLE
)的当前状态,而不是事件创建时的状态。