Information about events can be obtained as follows:
Query the EVENTS table of the
INFORMATION_SCHEMA database. See
Section 27.20, “The INFORMATION_SCHEMA EVENTS Table”.
Use the SHOW EVENTS statement. See
Section 12.5.5.16, “SHOW EVENTS”.
Use the SHOW CREATE EVENT statement. See
Section 12.5.5.7, “SHOW CREATE EVENT”.
A record of events executed on the server can be read from the MySQL Server's error log. See Section 25.5, “The Event Scheduler and MySQL Privileges” for an example.

User Comments
Add your own comment.