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