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