1INSERT INTO mysql.event (
2db,
3name,
4body,
5definer,
6interval_value,
7interval_field,
8originator,
9character_set_client,
10collation_connection,
11db_collation,
12body_utf8)
13values (
14database(),
15"ev1",
16"select 1",
17user(),
18100,
19"SECOND_MICROSECOND",
201,
21'utf8',
22'utf8_general_ci',
23'utf8_general_ci',
24'select 1');
25ERROR 22007: Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row 1
26set @orig_sql_mode=@@session.sql_mode;
27set session sql_mode="";
28Warnings:
29Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
30INSERT INTO mysql.event (
31db,
32name,
33body,
34definer,
35interval_value,
36interval_field,
37originator,
38character_set_client,
39collation_connection,
40db_collation,
41body_utf8)
42values (
43database(),
44"ev1",
45"select 1",
46user(),
47100,
48"SECOND_MICROSECOND",
491,
50'utf8',
51'utf8_general_ci',
52'utf8_general_ci',
53'select 1');
54set session sql_mode=@orig_sql_mode;
55Warnings:
56Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
57SHOW EVENTS;
58ERROR 42000: This version of MySQL doesn't yet support 'MICROSECOND'
59DROP EVENT ev1;
60SELECT TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
61FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ORDER BY TABLE_NAME;
62TABLE_NAME	COLUMN_NAME	REFERENCED_TABLE_NAME	REFERENCED_COLUMN_NAME
63columns_priv	Column_name	NULL	NULL
64columns_priv	Db	NULL	NULL
65columns_priv	Host	NULL	NULL
66columns_priv	Table_name	NULL	NULL
67columns_priv	User	NULL	NULL
68db	Db	NULL	NULL
69db	Host	NULL	NULL
70db	User	NULL	NULL
71engine_cost	cost_name	NULL	NULL
72engine_cost	device_type	NULL	NULL
73engine_cost	engine_name	NULL	NULL
74event	db	NULL	NULL
75event	name	NULL	NULL
76func	name	NULL	NULL
77gtid_executed	interval_start	NULL	NULL
78gtid_executed	source_uuid	NULL	NULL
79help_category	help_category_id	NULL	NULL
80help_category	name	NULL	NULL
81help_keyword	help_keyword_id	NULL	NULL
82help_keyword	name	NULL	NULL
83help_relation	help_keyword_id	NULL	NULL
84help_relation	help_topic_id	NULL	NULL
85help_topic	help_topic_id	NULL	NULL
86help_topic	name	NULL	NULL
87innodb_index_stats	database_name	NULL	NULL
88innodb_index_stats	index_name	NULL	NULL
89innodb_index_stats	stat_name	NULL	NULL
90innodb_index_stats	table_name	NULL	NULL
91innodb_table_stats	database_name	NULL	NULL
92innodb_table_stats	table_name	NULL	NULL
93ndb_binlog_index	epoch	NULL	NULL
94ndb_binlog_index	orig_epoch	NULL	NULL
95ndb_binlog_index	orig_server_id	NULL	NULL
96plugin	name	NULL	NULL
97proc	db	NULL	NULL
98proc	name	NULL	NULL
99proc	type	NULL	NULL
100procs_priv	Db	NULL	NULL
101procs_priv	Host	NULL	NULL
102procs_priv	Routine_name	NULL	NULL
103procs_priv	Routine_type	NULL	NULL
104procs_priv	User	NULL	NULL
105proxies_priv	Host	NULL	NULL
106proxies_priv	Proxied_host	NULL	NULL
107proxies_priv	Proxied_user	NULL	NULL
108proxies_priv	User	NULL	NULL
109server_cost	cost_name	NULL	NULL
110servers	Server_name	NULL	NULL
111slave_master_info	Channel_name	NULL	NULL
112slave_relay_log_info	Channel_name	NULL	NULL
113slave_worker_info	Channel_name	NULL	NULL
114slave_worker_info	Id	NULL	NULL
115sys_config	variable	NULL	NULL
116tables_priv	Db	NULL	NULL
117tables_priv	Host	NULL	NULL
118tables_priv	Table_name	NULL	NULL
119tables_priv	User	NULL	NULL
120time_zone	Time_zone_id	NULL	NULL
121time_zone_leap_second	Transition_time	NULL	NULL
122time_zone_name	Name	NULL	NULL
123time_zone_transition	Time_zone_id	NULL	NULL
124time_zone_transition	Transition_time	NULL	NULL
125time_zone_transition_type	Time_zone_id	NULL	NULL
126time_zone_transition_type	Transition_type_id	NULL	NULL
127user	Host	NULL	NULL
128user	User	NULL	NULL
129