MySQL 5.1 リファレンスマニュアル :: 19 Event Scheduler :: 19.3 Event Metadata
Information about events can be obtained as follows:
Querying the
EVENTStable of theINFORMATION_SCHEMAdatabase. See 項21.20. 「INFORMATION_SCHEMA EVENTSテーブル」.Using the
SHOW EVENTSstatement. See 項12.5.4.15. 「SHOW EVENTS」.Using the
SHOW CREATE EVENTstatement. See 項12.5.4.7. 「SHOW CREATE EVENT」.A record of events executed on the server can be read from the MySQL Server's error log (see 項19.5. 「The Event Scheduler and MySQL Privileges」 for an example).
