1# - Check SHOW CREATE statement; 2 3--echo 4--echo 5 6SHOW CREATE EVENT ev1| 7--echo 8SHOW CREATE EVENT ev2| 9--echo 10SHOW CREATE EVENT mysqltest2.ev3| 11--echo 12SHOW CREATE EVENT mysqltest2.ev3| 13 14# - Check SHOW statement; 15 16--echo 17--echo 18 19SHOW EVENTS LIKE 'ev1'| 20 21--echo 22SHOW EVENTS LIKE 'ev2'| 23 24--echo 25SHOW EVENTS LIKE 'ev3'| 26 27--echo 28SHOW EVENTS LIKE 'ev4'| 29 30# - Check INFORMATION_SCHEMA; 31 32--echo 33--echo 34 35--replace_column 17 CREATED 18 LAST_ALTERED 36SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'| 37 38--echo 39--replace_column 17 CREATED 18 LAST_ALTERED 40SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'| 41 42--echo 43--replace_column 17 CREATED 18 LAST_ALTERED 44SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'| 45 46--echo 47--replace_column 17 CREATED 18 LAST_ALTERED 48SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'| 49