MYSQL-查看创建的事件event语法(十)
13.7.5.7 SHOW CREATE EVENT 语句
SHOW CREATE EVENT event_name
此语句显示 CREATE EVENT
语句来重新创建给定事件。它 需要 EVENT
的 权限 要从中显示事件的数据库。例如 (使用定义的相同事件 然后在第 13.7.5.18 节 “SHOW EVENTS 语句”中更改):e_daily
mysql> SHOW CREATE EVENT myschema.e_daily\G
*************************** 1. row ***************************Event: e_dailysql_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_SUBSTITUTIONtime_zone: SYSTEMCreate Event: CREATE DEFINER=`jon`@`ghidora` EVENT `e_daily`ON SCHEDULE EVERY 1 DAYSTARTS CURRENT_TIMESTAMP + INTERVAL 6 HOURON COMPLETION NOT PRESERVEENABLECOMMENT 'Saves total number of sessions thenclears the table each day'DO BEGININSERT 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_ciDatabase Collation: latin1_swedish_ci