Information about events can be obtained as follows:
Querying the EVENTS table of the
INFORMATION_SCHEMA database. See
Section 23.20, “The INFORMATION_SCHEMA EVENTS Table”.
Using of the SHOW EVENTS and SHOW
FULL EVENTS statements. See
Section 126.96.36.199, “SHOW EVENTS”.
Using the SHOW CREATE EVENT statement. See
Section 188.8.131.52, “SHOW CREATE EVENT”.
SHOW CREATE EVENT
A record of events executed on the server can be read from the
MySQL Server's error log (see
Section 21.4, “The Event Scheduler and MySQL Privileges” for an example).