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