| 1 |
SELECT * FROM information_schema.columns |
| 2 |
WHERE table_schema = 'mysql' |
| 3 |
ORDER BY table_schema, table_name, column_name; |
| 4 |
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT IS_GENERATED GENERATION_EXPRESSION IS_SYSTEM_TIME_PERIOD_START IS_SYSTEM_TIME_PERIOD_END |
| 5 |
def mysql columns_priv Column_name 5 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 6 |
def mysql columns_priv Column_priv 7 '' NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') NEVER NULL NO NO |
| 7 |
def mysql columns_priv Db 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 8 |
def mysql columns_priv Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 9 |
def mysql columns_priv Table_name 4 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 10 |
def mysql columns_priv Timestamp 6 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 11 |
def mysql columns_priv User 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 12 |
def mysql column_stats avg_frequency 8 NULL YES decimal NULL NULL 12 4 NULL NULL NULL decimal(12,4) NEVER NULL NO NO |
| 13 |
def mysql column_stats avg_length 7 NULL YES decimal NULL NULL 12 4 NULL NULL NULL decimal(12,4) NEVER NULL NO NO |
| 14 |
def mysql column_stats column_name 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 15 |
def mysql column_stats db_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 16 |
def mysql column_stats histogram 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 17 |
def mysql column_stats hist_size 9 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned NEVER NULL NO NO |
| 18 |
def mysql column_stats hist_type 10 NULL YES enum 14 42 NULL NULL NULL utf8mb3 utf8mb3_bin enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB') NEVER NULL NO NO |
| 19 |
def mysql column_stats max_value 5 NULL YES varbinary 255 255 NULL NULL NULL NULL NULL varbinary(255) NEVER NULL NO NO |
| 20 |
def mysql column_stats min_value 4 NULL YES varbinary 255 255 NULL NULL NULL NULL NULL varbinary(255) NEVER NULL NO NO |
| 21 |
def mysql column_stats nulls_ratio 6 NULL YES decimal NULL NULL 12 4 NULL NULL NULL decimal(12,4) NEVER NULL NO NO |
| 22 |
def mysql column_stats table_name 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 23 |
def mysql db Alter_priv 13 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 24 |
def mysql db Alter_routine_priv 19 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 25 |
def mysql db Create_priv 8 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 26 |
def mysql db Create_routine_priv 18 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 27 |
def mysql db Create_tmp_table_priv 14 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 28 |
def mysql db Create_view_priv 16 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 29 |
def mysql db Db 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 30 |
def mysql db Delete_history_priv 23 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 31 |
def mysql db Delete_priv 7 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 32 |
def mysql db Drop_priv 9 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 33 |
def mysql db Event_priv 21 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 34 |
def mysql db Execute_priv 20 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 35 |
def mysql db Grant_priv 10 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 36 |
def mysql db Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 37 |
def mysql db Index_priv 12 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 38 |
def mysql db Insert_priv 5 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 39 |
def mysql db Lock_tables_priv 15 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 40 |
def mysql db References_priv 11 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 41 |
def mysql db Select_priv 4 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 42 |
def mysql db Show_create_routine_priv 24 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 43 |
def mysql db Show_view_priv 17 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 44 |
def mysql db Trigger_priv 22 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 45 |
def mysql db Update_priv 6 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 46 |
def mysql db User 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 47 |
def mysql event body 3 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 48 |
def mysql event body_utf8 22 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 49 |
def mysql event character_set_client 19 NULL YES char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) NEVER NULL NO NO |
| 50 |
def mysql event collation_connection 20 NULL YES char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) NEVER NULL NO NO |
| 51 |
def mysql event comment 16 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) NEVER NULL NO NO |
| 52 |
def mysql event created 8 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 53 |
def mysql event db 1 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 54 |
def mysql event db_collation 21 NULL YES char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) NEVER NULL NO NO |
| 55 |
def mysql event definer 4 '' NO varchar 384 1152 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(384) NEVER NULL NO NO |
| 56 |
def mysql event ends 12 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime NEVER NULL NO NO |
| 57 |
def mysql event execute_at 5 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime NEVER NULL NO NO |
| 58 |
def mysql event interval_field 7 NULL YES enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') NEVER NULL NO NO |
| 59 |
def mysql event interval_value 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int(11) NEVER NULL NO NO |
| 60 |
def mysql event last_executed 10 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime NEVER NULL NO NO |
| 61 |
def mysql event modified 9 '0000-00-00 00:00:00' NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp NEVER NULL NO NO |
| 62 |
def mysql event name 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI NEVER NULL NO NO |
| 63 |
def mysql event on_completion 14 'DROP' NO enum 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('DROP','PRESERVE') NEVER NULL NO NO |
| 64 |
def mysql event originator 17 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 65 |
def mysql event sql_mode 15 '' NO set 561 1683 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') NEVER NULL NO NO |
| 66 |
def mysql event starts 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime NEVER NULL NO NO |
| 67 |
def mysql event status 13 'ENABLED' NO enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NEVER NULL NO NO |
| 68 |
def mysql event time_zone 18 'SYSTEM' NO char 64 64 NULL NULL NULL latin1 latin1_swedish_ci char(64) NEVER NULL NO NO |
| 69 |
def mysql func dl 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) NEVER NULL NO NO |
| 70 |
def mysql func name 1 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 71 |
def mysql func ret 2 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) NEVER NULL NO NO |
| 72 |
def mysql func type 4 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('function','aggregate') NEVER NULL NO NO |
| 73 |
def mysql general_log argument 6 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext NEVER NULL NO NO |
| 74 |
def mysql general_log command_type 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) NEVER NULL NO NO |
| 75 |
def mysql general_log event_time 1 current_timestamp(6) NO timestamp NULL NULL NULL NULL 6 NULL NULL timestamp(6) on update current_timestamp(6) NEVER NULL NO NO |
| 76 |
def mysql general_log server_id 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 77 |
def mysql general_log thread_id 3 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned NEVER NULL NO NO |
| 78 |
def mysql general_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext NEVER NULL NO NO |
| 79 |
def mysql global_priv Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 80 |
def mysql global_priv Priv 3 '{}' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 81 |
def mysql global_priv User 2 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 82 |
def mysql gtid_slave_pos domain_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 83 |
def mysql gtid_slave_pos seq_no 4 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 84 |
def mysql gtid_slave_pos server_id 3 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 85 |
def mysql gtid_slave_pos sub_id 2 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned PRI NEVER NULL NO NO |
| 86 |
def mysql help_category help_category_id 1 NULL NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned PRI NEVER NULL NO NO |
| 87 |
def mysql help_category name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI NEVER NULL NO NO |
| 88 |
def mysql help_category parent_category_id 3 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned NEVER NULL NO NO |
| 89 |
def mysql help_category url 4 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text NEVER NULL NO NO |
| 90 |
def mysql help_keyword help_keyword_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 91 |
def mysql help_keyword name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI NEVER NULL NO NO |
| 92 |
def mysql help_relation help_keyword_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 93 |
def mysql help_relation help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 94 |
def mysql help_topic description 4 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text NEVER NULL NO NO |
| 95 |
def mysql help_topic example 5 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text NEVER NULL NO NO |
| 96 |
def mysql help_topic help_category_id 3 NULL NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned NEVER NULL NO NO |
| 97 |
def mysql help_topic help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 98 |
def mysql help_topic name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI NEVER NULL NO NO |
| 99 |
def mysql help_topic url 6 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text NEVER NULL NO NO |
| 100 |
def mysql index_stats avg_frequency 5 NULL YES decimal NULL NULL 12 4 NULL NULL NULL decimal(12,4) NEVER NULL NO NO |
| 101 |
def mysql index_stats db_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 102 |
def mysql index_stats index_name 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 103 |
def mysql index_stats prefix_arity 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int(11) unsigned PRI NEVER NULL NO NO |
| 104 |
def mysql index_stats table_name 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 105 |
def mysql plugin dl 2 '' NO varchar 128 384 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(128) NEVER NULL NO NO |
| 106 |
def mysql plugin name 1 '' NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI NEVER NULL NO NO |
| 107 |
def mysql proc aggregate 21 'NONE' NO enum 5 15 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('NONE','GROUP') NEVER NULL NO NO |
| 108 |
def mysql proc body 11 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 109 |
def mysql proc body_utf8 20 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 110 |
def mysql proc character_set_client 17 NULL YES char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) NEVER NULL NO NO |
| 111 |
def mysql proc collation_connection 18 NULL YES char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) NEVER NULL NO NO |
| 112 |
def mysql proc comment 16 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text NEVER NULL NO NO |
| 113 |
def mysql proc created 13 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 114 |
def mysql proc db 1 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 115 |
def mysql proc db_collation 19 NULL YES char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) NEVER NULL NO NO |
| 116 |
def mysql proc definer 12 '' NO varchar 384 1152 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(384) NEVER NULL NO NO |
| 117 |
def mysql proc is_deterministic 7 'NO' NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('YES','NO') NEVER NULL NO NO |
| 118 |
def mysql proc language 5 'SQL' NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('SQL') NEVER NULL NO NO |
| 119 |
def mysql proc modified 14 '0000-00-00 00:00:00' NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp NEVER NULL NO NO |
| 120 |
def mysql proc name 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI NEVER NULL NO NO |
| 121 |
def mysql proc param_list 9 NULL NO blob 65535 65535 NULL NULL NULL NULL NULL blob NEVER NULL NO NO |
| 122 |
def mysql proc returns 10 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob NEVER NULL NO NO |
| 123 |
def mysql proc security_type 8 'DEFINER' NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('INVOKER','DEFINER') NEVER NULL NO NO |
| 124 |
def mysql proc specific_name 4 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) NEVER NULL NO NO |
| 125 |
def mysql proc sql_data_access 6 'CONTAINS_SQL' NO enum 17 51 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NEVER NULL NO NO |
| 126 |
def mysql proc sql_mode 15 '' NO set 561 1683 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') NEVER NULL NO NO |
| 127 |
def mysql proc type 3 NULL NO enum 12 36 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') PRI NEVER NULL NO NO |
| 128 |
def mysql procs_priv Db 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 129 |
def mysql procs_priv Grantor 6 '' NO varchar 384 1152 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(384) MUL NEVER NULL NO NO |
| 130 |
def mysql procs_priv Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 131 |
def mysql procs_priv Proc_priv 7 '' NO set 47 141 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant','Show Create Routine') NEVER NULL NO NO |
| 132 |
def mysql procs_priv Routine_name 4 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI NEVER NULL NO NO |
| 133 |
def mysql procs_priv Routine_type 5 NULL NO enum 12 36 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') PRI NEVER NULL NO NO |
| 134 |
def mysql procs_priv Timestamp 8 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 135 |
def mysql procs_priv User 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 136 |
def mysql proxies_priv Grantor 6 '' NO varchar 384 1152 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(384) MUL NEVER NULL NO NO |
| 137 |
def mysql proxies_priv Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 138 |
def mysql proxies_priv Proxied_host 3 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 139 |
def mysql proxies_priv Proxied_user 4 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 140 |
def mysql proxies_priv Timestamp 7 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 141 |
def mysql proxies_priv User 2 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 142 |
def mysql proxies_priv With_grant 5 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) NEVER NULL NO NO |
| 143 |
def mysql roles_mapping Admin_option 4 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') NEVER NULL NO NO |
| 144 |
def mysql roles_mapping Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 145 |
def mysql roles_mapping Role 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 146 |
def mysql roles_mapping User 2 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 147 |
def mysql servers Db 3 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) NEVER NULL NO NO |
| 148 |
def mysql servers Host 2 '' NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) NEVER NULL NO NO |
| 149 |
def mysql servers Options 10 '{}' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 150 |
def mysql servers Owner 9 '' NO varchar 512 1536 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) NEVER NULL NO NO |
| 151 |
def mysql servers Password 5 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) NEVER NULL NO NO |
| 152 |
def mysql servers Port 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(4) NEVER NULL NO NO |
| 153 |
def mysql servers Server_name 1 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI NEVER NULL NO NO |
| 154 |
def mysql servers Socket 7 '' NO char 108 324 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(108) NEVER NULL NO NO |
| 155 |
def mysql servers Username 4 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(128) NEVER NULL NO NO |
| 156 |
def mysql servers Wrapper 8 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) NEVER NULL NO NO |
| 157 |
def mysql slow_log db 7 NULL NO varchar 512 1536 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) NEVER NULL NO NO |
| 158 |
def mysql slow_log insert_id 9 NULL NO int NULL NULL 10 0 NULL NULL NULL int(11) NEVER NULL NO NO |
| 159 |
def mysql slow_log last_insert_id 8 NULL NO int NULL NULL 10 0 NULL NULL NULL int(11) NEVER NULL NO NO |
| 160 |
def mysql slow_log lock_time 4 NULL NO time NULL NULL NULL NULL 6 NULL NULL time(6) NEVER NULL NO NO |
| 161 |
def mysql slow_log query_time 3 NULL NO time NULL NULL NULL NULL 6 NULL NULL time(6) NEVER NULL NO NO |
| 162 |
def mysql slow_log rows_affected 13 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 163 |
def mysql slow_log rows_examined 6 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 164 |
def mysql slow_log rows_sent 5 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 165 |
def mysql slow_log server_id 10 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 166 |
def mysql slow_log sql_text 11 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext NEVER NULL NO NO |
| 167 |
def mysql slow_log start_time 1 current_timestamp(6) NO timestamp NULL NULL NULL NULL 6 NULL NULL timestamp(6) on update current_timestamp(6) NEVER NULL NO NO |
| 168 |
def mysql slow_log thread_id 12 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned NEVER NULL NO NO |
| 169 |
def mysql slow_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext NEVER NULL NO NO |
| 170 |
def mysql tables_priv Column_priv 8 '' NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') NEVER NULL NO NO |
| 171 |
def mysql tables_priv Db 2 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 172 |
def mysql tables_priv Grantor 5 '' NO varchar 384 1152 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(384) MUL NEVER NULL NO NO |
| 173 |
def mysql tables_priv Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) PRI NEVER NULL NO NO |
| 174 |
def mysql tables_priv Table_name 4 '' NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI NEVER NULL NO NO |
| 175 |
def mysql tables_priv Table_priv 7 '' NO set 121 363 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger','Delete versioning rows') NEVER NULL NO NO |
| 176 |
def mysql tables_priv Timestamp 6 current_timestamp() NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp on update current_timestamp() NEVER NULL NO NO |
| 177 |
def mysql tables_priv User 3 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) PRI NEVER NULL NO NO |
| 178 |
def mysql table_stats cardinality 3 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned NEVER NULL NO NO |
| 179 |
def mysql table_stats db_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 180 |
def mysql table_stats table_name 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI NEVER NULL NO NO |
| 181 |
def mysql time_zone Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI auto_increment NEVER NULL NO NO |
| 182 |
def mysql time_zone Use_leap_seconds 2 'N' NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('Y','N') NEVER NULL NO NO |
| 183 |
def mysql time_zone_leap_second Correction 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int(11) NEVER NULL NO NO |
| 184 |
def mysql time_zone_leap_second Transition_time 1 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint(20) PRI NEVER NULL NO NO |
| 185 |
def mysql time_zone_name Name 1 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI NEVER NULL NO NO |
| 186 |
def mysql time_zone_name Time_zone_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 187 |
def mysql time_zone_transition Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 188 |
def mysql time_zone_transition Transition_time 2 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint(20) PRI NEVER NULL NO NO |
| 189 |
def mysql time_zone_transition Transition_type_id 3 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned NEVER NULL NO NO |
| 190 |
def mysql time_zone_transition_type Abbreviation 5 '' NO char 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(8) NEVER NULL NO NO |
| 191 |
def mysql time_zone_transition_type Is_DST 4 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned NEVER NULL NO NO |
| 192 |
def mysql time_zone_transition_type Offset 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(11) NEVER NULL NO NO |
| 193 |
def mysql time_zone_transition_type Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 194 |
def mysql time_zone_transition_type Transition_type_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned PRI NEVER NULL NO NO |
| 195 |
def mysql user Alter_priv 17 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 196 |
def mysql user Alter_routine_priv 28 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 197 |
def mysql user authentication_string 43 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 198 |
def mysql user Create_priv 8 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 199 |
def mysql user Create_routine_priv 27 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 200 |
def mysql user Create_tablespace_priv 32 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 201 |
def mysql user Create_tmp_table_priv 20 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 202 |
def mysql user Create_user_priv 29 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 203 |
def mysql user Create_view_priv 25 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 204 |
def mysql user default_role 46 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 205 |
def mysql user Delete_history_priv 33 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 206 |
def mysql user Delete_priv 7 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 207 |
def mysql user Drop_priv 9 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 208 |
def mysql user Event_priv 30 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 209 |
def mysql user Execute_priv 22 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 210 |
def mysql user File_priv 13 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 211 |
def mysql user Grant_priv 14 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 212 |
def mysql user Host 1 '' NO char 255 765 NULL NULL NULL utf8mb3 utf8mb3_bin char(255) NEVER NULL NO NO |
| 213 |
def mysql user Index_priv 16 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 214 |
def mysql user Insert_priv 5 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 215 |
def mysql user is_role 45 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 216 |
def mysql user Lock_tables_priv 21 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 217 |
def mysql user max_connections 40 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 218 |
def mysql user max_questions 38 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 219 |
def mysql user max_statement_time 47 0.000000 NO decimal NULL NULL 12 6 NULL NULL NULL decimal(12,6) NEVER NULL NO NO |
| 220 |
def mysql user max_updates 39 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned NEVER NULL NO NO |
| 221 |
def mysql user max_user_connections 41 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(21) NEVER NULL NO NO |
| 222 |
def mysql user Password 3 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 223 |
def mysql user password_expired 44 '' NO varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 224 |
def mysql user plugin 42 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 225 |
def mysql user Process_priv 12 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 226 |
def mysql user References_priv 15 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 227 |
def mysql user Reload_priv 10 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 228 |
def mysql user Repl_client_priv 24 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 229 |
def mysql user Repl_slave_priv 23 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 230 |
def mysql user Select_priv 4 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 231 |
def mysql user Show_db_priv 18 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 232 |
def mysql user Show_view_priv 26 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 233 |
def mysql user Shutdown_priv 11 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 234 |
def mysql user ssl_cipher 35 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 235 |
def mysql user ssl_type 34 NULL YES varchar 9 9 NULL NULL NULL latin1 latin1_swedish_ci varchar(9) NEVER NULL NO NO |
| 236 |
def mysql user Super_priv 19 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 237 |
def mysql user Trigger_priv 31 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 238 |
def mysql user Update_priv 6 NULL YES varchar 1 1 NULL NULL NULL latin1 latin1_swedish_ci varchar(1) NEVER NULL NO NO |
| 239 |
def mysql user User 2 '' NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) NEVER NULL NO NO |
| 240 |
def mysql user x509_issuer 36 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 241 |
def mysql user x509_subject 37 '' NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext NEVER NULL NO NO |
| 242 |
Warnings: |
| 243 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 244 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 245 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 246 |
########################################################################## |
| 247 |
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH |
| 248 |
########################################################################## |
| 249 |
SELECT DISTINCT |
| 250 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 251 |
DATA_TYPE, |
| 252 |
CHARACTER_SET_NAME, |
| 253 |
COLLATION_NAME |
| 254 |
FROM information_schema.columns |
| 255 |
WHERE table_schema = 'mysql' |
| 256 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1 |
| 257 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML; |
| 258 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 259 |
1.0000 blob NULL NULL |
| 260 |
1.0000 longblob NULL NULL |
| 261 |
1.0000 varbinary NULL NULL |
| 262 |
1.0000 char latin1 latin1_swedish_ci |
| 263 |
1.0000 varchar latin1 latin1_swedish_ci |
| 264 |
1.0000 text utf8mb3 utf8mb3_bin |
| 265 |
1.0000 mediumtext utf8mb3 utf8mb3_general_ci |
| 266 |
1.0000 text utf8mb3 utf8mb3_general_ci |
| 267 |
1.0000 longtext utf8mb4 utf8mb4_bin |
| 268 |
Warnings: |
| 269 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 270 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 271 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 272 |
SELECT DISTINCT |
| 273 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 274 |
DATA_TYPE, |
| 275 |
CHARACTER_SET_NAME, |
| 276 |
COLLATION_NAME |
| 277 |
FROM information_schema.columns |
| 278 |
WHERE table_schema = 'mysql' |
| 279 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1 |
| 280 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML; |
| 281 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 282 |
3.0000 char utf8mb3 utf8mb3_bin |
| 283 |
3.0000 enum utf8mb3 utf8mb3_bin |
| 284 |
3.0000 varchar utf8mb3 utf8mb3_bin |
| 285 |
3.0000 char utf8mb3 utf8mb3_general_ci |
| 286 |
3.0000 enum utf8mb3 utf8mb3_general_ci |
| 287 |
3.0000 set utf8mb3 utf8mb3_general_ci |
| 288 |
3.0000 varchar utf8mb3 utf8mb3_general_ci |
| 289 |
Warnings: |
| 290 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 291 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 292 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 293 |
SELECT DISTINCT |
| 294 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 295 |
DATA_TYPE, |
| 296 |
CHARACTER_SET_NAME, |
| 297 |
COLLATION_NAME |
| 298 |
FROM information_schema.columns |
| 299 |
WHERE table_schema = 'mysql' |
| 300 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL |
| 301 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML; |
| 302 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 303 |
NULL bigint NULL NULL |
| 304 |
NULL datetime NULL NULL |
| 305 |
NULL decimal NULL NULL |
| 306 |
NULL int NULL NULL |
| 307 |
NULL smallint NULL NULL |
| 308 |
NULL time NULL NULL |
| 309 |
NULL timestamp NULL NULL |
| 310 |
NULL tinyint NULL NULL |
| 311 |
Warnings: |
| 312 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 313 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 314 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 315 |
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values |
| 316 |
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL |
| 317 |
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 318 |
TABLE_SCHEMA, |
| 319 |
TABLE_NAME, |
| 320 |
COLUMN_NAME, |
| 321 |
DATA_TYPE, |
| 322 |
CHARACTER_MAXIMUM_LENGTH, |
| 323 |
CHARACTER_OCTET_LENGTH, |
| 324 |
CHARACTER_SET_NAME, |
| 325 |
COLLATION_NAME, |
| 326 |
COLUMN_TYPE |
| 327 |
FROM information_schema.columns |
| 328 |
WHERE table_schema = 'mysql' |
| 329 |
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION; |
| 330 |
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE |
| 331 |
3.0000 mysql columns_priv Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 332 |
3.0000 mysql columns_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 333 |
3.0000 mysql columns_priv User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 334 |
3.0000 mysql columns_priv Table_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 335 |
3.0000 mysql columns_priv Column_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 336 |
NULL mysql columns_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 337 |
3.0000 mysql columns_priv Column_priv set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') |
| 338 |
3.0000 mysql column_stats db_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 339 |
3.0000 mysql column_stats table_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 340 |
3.0000 mysql column_stats column_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 341 |
1.0000 mysql column_stats min_value varbinary 255 255 NULL NULL varbinary(255) |
| 342 |
1.0000 mysql column_stats max_value varbinary 255 255 NULL NULL varbinary(255) |
| 343 |
NULL mysql column_stats nulls_ratio decimal NULL NULL NULL NULL decimal(12,4) |
| 344 |
NULL mysql column_stats avg_length decimal NULL NULL NULL NULL decimal(12,4) |
| 345 |
NULL mysql column_stats avg_frequency decimal NULL NULL NULL NULL decimal(12,4) |
| 346 |
NULL mysql column_stats hist_size tinyint NULL NULL NULL NULL tinyint(3) unsigned |
| 347 |
3.0000 mysql column_stats hist_type enum 14 42 utf8mb3 utf8mb3_bin enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB') |
| 348 |
1.0000 mysql column_stats histogram longblob 4294967295 4294967295 NULL NULL longblob |
| 349 |
3.0000 mysql db Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 350 |
3.0000 mysql db Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 351 |
3.0000 mysql db User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 352 |
3.0000 mysql db Select_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 353 |
3.0000 mysql db Insert_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 354 |
3.0000 mysql db Update_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 355 |
3.0000 mysql db Delete_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 356 |
3.0000 mysql db Create_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 357 |
3.0000 mysql db Drop_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 358 |
3.0000 mysql db Grant_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 359 |
3.0000 mysql db References_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 360 |
3.0000 mysql db Index_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 361 |
3.0000 mysql db Alter_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 362 |
3.0000 mysql db Create_tmp_table_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 363 |
3.0000 mysql db Lock_tables_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 364 |
3.0000 mysql db Create_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 365 |
3.0000 mysql db Show_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 366 |
3.0000 mysql db Create_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 367 |
3.0000 mysql db Alter_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 368 |
3.0000 mysql db Execute_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 369 |
3.0000 mysql db Event_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 370 |
3.0000 mysql db Trigger_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 371 |
3.0000 mysql db Delete_history_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 372 |
3.0000 mysql db Show_create_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 373 |
3.0000 mysql event db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 374 |
3.0000 mysql event name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 375 |
1.0000 mysql event body longblob 4294967295 4294967295 NULL NULL longblob |
| 376 |
3.0000 mysql event definer varchar 384 1152 utf8mb3 utf8mb3_bin varchar(384) |
| 377 |
NULL mysql event execute_at datetime NULL NULL NULL NULL datetime |
| 378 |
NULL mysql event interval_value int NULL NULL NULL NULL int(11) |
| 379 |
3.0000 mysql event interval_field enum 18 54 utf8mb3 utf8mb3_general_ci enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') |
| 380 |
NULL mysql event created timestamp NULL NULL NULL NULL timestamp |
| 381 |
NULL mysql event modified timestamp NULL NULL NULL NULL timestamp |
| 382 |
NULL mysql event last_executed datetime NULL NULL NULL NULL datetime |
| 383 |
NULL mysql event starts datetime NULL NULL NULL NULL datetime |
| 384 |
NULL mysql event ends datetime NULL NULL NULL NULL datetime |
| 385 |
3.0000 mysql event status enum 18 54 utf8mb3 utf8mb3_general_ci enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') |
| 386 |
3.0000 mysql event on_completion enum 8 24 utf8mb3 utf8mb3_general_ci enum('DROP','PRESERVE') |
| 387 |
3.0000 mysql event sql_mode set 561 1683 utf8mb3 utf8mb3_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') |
| 388 |
3.0000 mysql event comment char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 389 |
NULL mysql event originator int NULL NULL NULL NULL int(10) unsigned |
| 390 |
1.0000 mysql event time_zone char 64 64 latin1 latin1_swedish_ci char(64) |
| 391 |
3.0000 mysql event character_set_client char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 392 |
3.0000 mysql event collation_connection char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 393 |
3.0000 mysql event db_collation char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 394 |
1.0000 mysql event body_utf8 longblob 4294967295 4294967295 NULL NULL longblob |
| 395 |
3.0000 mysql func name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 396 |
NULL mysql func ret tinyint NULL NULL NULL NULL tinyint(1) |
| 397 |
3.0000 mysql func dl char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 398 |
3.0000 mysql func type enum 9 27 utf8mb3 utf8mb3_general_ci enum('function','aggregate') |
| 399 |
NULL mysql general_log event_time timestamp NULL NULL NULL NULL timestamp(6) |
| 400 |
1.0000 mysql general_log user_host mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 401 |
NULL mysql general_log thread_id bigint NULL NULL NULL NULL bigint(21) unsigned |
| 402 |
NULL mysql general_log server_id int NULL NULL NULL NULL int(10) unsigned |
| 403 |
3.0000 mysql general_log command_type varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 404 |
1.0000 mysql general_log argument mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 405 |
3.0000 mysql global_priv Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 406 |
3.0000 mysql global_priv User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 407 |
1.0000 mysql global_priv Priv longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 408 |
NULL mysql gtid_slave_pos domain_id int NULL NULL NULL NULL int(10) unsigned |
| 409 |
NULL mysql gtid_slave_pos sub_id bigint NULL NULL NULL NULL bigint(20) unsigned |
| 410 |
NULL mysql gtid_slave_pos server_id int NULL NULL NULL NULL int(10) unsigned |
| 411 |
NULL mysql gtid_slave_pos seq_no bigint NULL NULL NULL NULL bigint(20) unsigned |
| 412 |
NULL mysql help_category help_category_id smallint NULL NULL NULL NULL smallint(5) unsigned |
| 413 |
3.0000 mysql help_category name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 414 |
NULL mysql help_category parent_category_id smallint NULL NULL NULL NULL smallint(5) unsigned |
| 415 |
1.0000 mysql help_category url text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 416 |
NULL mysql help_keyword help_keyword_id int NULL NULL NULL NULL int(10) unsigned |
| 417 |
3.0000 mysql help_keyword name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 418 |
NULL mysql help_relation help_topic_id int NULL NULL NULL NULL int(10) unsigned |
| 419 |
NULL mysql help_relation help_keyword_id int NULL NULL NULL NULL int(10) unsigned |
| 420 |
NULL mysql help_topic help_topic_id int NULL NULL NULL NULL int(10) unsigned |
| 421 |
3.0000 mysql help_topic name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 422 |
NULL mysql help_topic help_category_id smallint NULL NULL NULL NULL smallint(5) unsigned |
| 423 |
1.0000 mysql help_topic description text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 424 |
1.0000 mysql help_topic example text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 425 |
1.0000 mysql help_topic url text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 426 |
3.0000 mysql index_stats db_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 427 |
3.0000 mysql index_stats table_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 428 |
3.0000 mysql index_stats index_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 429 |
NULL mysql index_stats prefix_arity int NULL NULL NULL NULL int(11) unsigned |
| 430 |
NULL mysql index_stats avg_frequency decimal NULL NULL NULL NULL decimal(12,4) |
| 431 |
3.0000 mysql plugin name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 432 |
3.0000 mysql plugin dl varchar 128 384 utf8mb3 utf8mb3_general_ci varchar(128) |
| 433 |
3.0000 mysql proc db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 434 |
3.0000 mysql proc name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 435 |
3.0000 mysql proc type enum 12 36 utf8mb3 utf8mb3_general_ci enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') |
| 436 |
3.0000 mysql proc specific_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 437 |
3.0000 mysql proc language enum 3 9 utf8mb3 utf8mb3_general_ci enum('SQL') |
| 438 |
3.0000 mysql proc sql_data_access enum 17 51 utf8mb3 utf8mb3_general_ci enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') |
| 439 |
3.0000 mysql proc is_deterministic enum 3 9 utf8mb3 utf8mb3_general_ci enum('YES','NO') |
| 440 |
3.0000 mysql proc security_type enum 7 21 utf8mb3 utf8mb3_general_ci enum('INVOKER','DEFINER') |
| 441 |
1.0000 mysql proc param_list blob 65535 65535 NULL NULL blob |
| 442 |
1.0000 mysql proc returns longblob 4294967295 4294967295 NULL NULL longblob |
| 443 |
1.0000 mysql proc body longblob 4294967295 4294967295 NULL NULL longblob |
| 444 |
3.0000 mysql proc definer varchar 384 1152 utf8mb3 utf8mb3_bin varchar(384) |
| 445 |
NULL mysql proc created timestamp NULL NULL NULL NULL timestamp |
| 446 |
NULL mysql proc modified timestamp NULL NULL NULL NULL timestamp |
| 447 |
3.0000 mysql proc sql_mode set 561 1683 utf8mb3 utf8mb3_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') |
| 448 |
1.0000 mysql proc comment text 65535 65535 utf8mb3 utf8mb3_bin text |
| 449 |
3.0000 mysql proc character_set_client char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 450 |
3.0000 mysql proc collation_connection char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 451 |
3.0000 mysql proc db_collation char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 452 |
1.0000 mysql proc body_utf8 longblob 4294967295 4294967295 NULL NULL longblob |
| 453 |
3.0000 mysql proc aggregate enum 5 15 utf8mb3 utf8mb3_general_ci enum('NONE','GROUP') |
| 454 |
3.0000 mysql procs_priv Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 455 |
3.0000 mysql procs_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 456 |
3.0000 mysql procs_priv User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 457 |
3.0000 mysql procs_priv Routine_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 458 |
3.0000 mysql procs_priv Routine_type enum 12 36 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') |
| 459 |
3.0000 mysql procs_priv Grantor varchar 384 1152 utf8mb3 utf8mb3_bin varchar(384) |
| 460 |
3.0000 mysql procs_priv Proc_priv set 47 141 utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant','Show Create Routine') |
| 461 |
NULL mysql procs_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 462 |
3.0000 mysql proxies_priv Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 463 |
3.0000 mysql proxies_priv User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 464 |
3.0000 mysql proxies_priv Proxied_host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 465 |
3.0000 mysql proxies_priv Proxied_user char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 466 |
NULL mysql proxies_priv With_grant tinyint NULL NULL NULL NULL tinyint(1) |
| 467 |
3.0000 mysql proxies_priv Grantor varchar 384 1152 utf8mb3 utf8mb3_bin varchar(384) |
| 468 |
NULL mysql proxies_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 469 |
3.0000 mysql roles_mapping Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 470 |
3.0000 mysql roles_mapping User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 471 |
3.0000 mysql roles_mapping Role char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 472 |
3.0000 mysql roles_mapping Admin_option enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 473 |
3.0000 mysql servers Server_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 474 |
3.0000 mysql servers Host varchar 2048 6144 utf8mb3 utf8mb3_general_ci varchar(2048) |
| 475 |
3.0000 mysql servers Db char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 476 |
3.0000 mysql servers Username char 128 384 utf8mb3 utf8mb3_general_ci char(128) |
| 477 |
3.0000 mysql servers Password char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 478 |
NULL mysql servers Port int NULL NULL NULL NULL int(4) |
| 479 |
3.0000 mysql servers Socket char 108 324 utf8mb3 utf8mb3_general_ci char(108) |
| 480 |
3.0000 mysql servers Wrapper char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 481 |
3.0000 mysql servers Owner varchar 512 1536 utf8mb3 utf8mb3_general_ci varchar(512) |
| 482 |
1.0000 mysql servers Options longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 483 |
NULL mysql slow_log start_time timestamp NULL NULL NULL NULL timestamp(6) |
| 484 |
1.0000 mysql slow_log user_host mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 485 |
NULL mysql slow_log query_time time NULL NULL NULL NULL time(6) |
| 486 |
NULL mysql slow_log lock_time time NULL NULL NULL NULL time(6) |
| 487 |
NULL mysql slow_log rows_sent bigint NULL NULL NULL NULL bigint(20) unsigned |
| 488 |
NULL mysql slow_log rows_examined bigint NULL NULL NULL NULL bigint(20) unsigned |
| 489 |
3.0000 mysql slow_log db varchar 512 1536 utf8mb3 utf8mb3_general_ci varchar(512) |
| 490 |
NULL mysql slow_log last_insert_id int NULL NULL NULL NULL int(11) |
| 491 |
NULL mysql slow_log insert_id int NULL NULL NULL NULL int(11) |
| 492 |
NULL mysql slow_log server_id int NULL NULL NULL NULL int(10) unsigned |
| 493 |
1.0000 mysql slow_log sql_text mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 494 |
NULL mysql slow_log thread_id bigint NULL NULL NULL NULL bigint(21) unsigned |
| 495 |
NULL mysql slow_log rows_affected bigint NULL NULL NULL NULL bigint(20) unsigned |
| 496 |
3.0000 mysql tables_priv Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 497 |
3.0000 mysql tables_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 498 |
3.0000 mysql tables_priv User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 499 |
3.0000 mysql tables_priv Table_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 500 |
3.0000 mysql tables_priv Grantor varchar 384 1152 utf8mb3 utf8mb3_bin varchar(384) |
| 501 |
NULL mysql tables_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 502 |
3.0000 mysql tables_priv Table_priv set 121 363 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger','Delete versioning rows') |
| 503 |
3.0000 mysql tables_priv Column_priv set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') |
| 504 |
3.0000 mysql table_stats db_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 505 |
3.0000 mysql table_stats table_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 506 |
NULL mysql table_stats cardinality bigint NULL NULL NULL NULL bigint(21) unsigned |
| 507 |
NULL mysql time_zone Time_zone_id int NULL NULL NULL NULL int(10) unsigned |
| 508 |
3.0000 mysql time_zone Use_leap_seconds enum 1 3 utf8mb3 utf8mb3_general_ci enum('Y','N') |
| 509 |
NULL mysql time_zone_leap_second Transition_time bigint NULL NULL NULL NULL bigint(20) |
| 510 |
NULL mysql time_zone_leap_second Correction int NULL NULL NULL NULL int(11) |
| 511 |
3.0000 mysql time_zone_name Name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 512 |
NULL mysql time_zone_name Time_zone_id int NULL NULL NULL NULL int(10) unsigned |
| 513 |
NULL mysql time_zone_transition Time_zone_id int NULL NULL NULL NULL int(10) unsigned |
| 514 |
NULL mysql time_zone_transition Transition_time bigint NULL NULL NULL NULL bigint(20) |
| 515 |
NULL mysql time_zone_transition Transition_type_id int NULL NULL NULL NULL int(10) unsigned |
| 516 |
NULL mysql time_zone_transition_type Time_zone_id int NULL NULL NULL NULL int(10) unsigned |
| 517 |
NULL mysql time_zone_transition_type Transition_type_id int NULL NULL NULL NULL int(10) unsigned |
| 518 |
NULL mysql time_zone_transition_type Offset int NULL NULL NULL NULL int(11) |
| 519 |
NULL mysql time_zone_transition_type Is_DST tinyint NULL NULL NULL NULL tinyint(3) unsigned |
| 520 |
3.0000 mysql time_zone_transition_type Abbreviation char 8 24 utf8mb3 utf8mb3_general_ci char(8) |
| 521 |
3.0000 mysql user Host char 255 765 utf8mb3 utf8mb3_bin char(255) |
| 522 |
3.0000 mysql user User char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 523 |
1.0000 mysql user Password longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 524 |
1.0000 mysql user Select_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 525 |
1.0000 mysql user Insert_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 526 |
1.0000 mysql user Update_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 527 |
1.0000 mysql user Delete_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 528 |
1.0000 mysql user Create_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 529 |
1.0000 mysql user Drop_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 530 |
1.0000 mysql user Reload_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 531 |
1.0000 mysql user Shutdown_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 532 |
1.0000 mysql user Process_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 533 |
1.0000 mysql user File_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 534 |
1.0000 mysql user Grant_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 535 |
1.0000 mysql user References_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 536 |
1.0000 mysql user Index_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 537 |
1.0000 mysql user Alter_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 538 |
1.0000 mysql user Show_db_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 539 |
1.0000 mysql user Super_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 540 |
1.0000 mysql user Create_tmp_table_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 541 |
1.0000 mysql user Lock_tables_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 542 |
1.0000 mysql user Execute_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 543 |
1.0000 mysql user Repl_slave_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 544 |
1.0000 mysql user Repl_client_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 545 |
1.0000 mysql user Create_view_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 546 |
1.0000 mysql user Show_view_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 547 |
1.0000 mysql user Create_routine_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 548 |
1.0000 mysql user Alter_routine_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 549 |
1.0000 mysql user Create_user_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 550 |
1.0000 mysql user Event_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 551 |
1.0000 mysql user Trigger_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 552 |
1.0000 mysql user Create_tablespace_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 553 |
1.0000 mysql user Delete_history_priv varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 554 |
1.0000 mysql user ssl_type varchar 9 9 latin1 latin1_swedish_ci varchar(9) |
| 555 |
1.0000 mysql user ssl_cipher longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 556 |
1.0000 mysql user x509_issuer longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 557 |
1.0000 mysql user x509_subject longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 558 |
NULL mysql user max_questions bigint NULL NULL NULL NULL bigint(20) unsigned |
| 559 |
NULL mysql user max_updates bigint NULL NULL NULL NULL bigint(20) unsigned |
| 560 |
NULL mysql user max_connections bigint NULL NULL NULL NULL bigint(20) unsigned |
| 561 |
NULL mysql user max_user_connections bigint NULL NULL NULL NULL bigint(21) |
| 562 |
1.0000 mysql user plugin longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 563 |
1.0000 mysql user authentication_string longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 564 |
1.0000 mysql user password_expired varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 565 |
1.0000 mysql user is_role varchar 1 1 latin1 latin1_swedish_ci varchar(1) |
| 566 |
1.0000 mysql user default_role longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 567 |
NULL mysql user max_statement_time decimal NULL NULL NULL NULL decimal(12,6) |
| 568 |
Warnings: |
| 569 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 570 |
Warning 1286 Unknown storage engine 'InnoDB' |
| 571 |
Warning 1286 Unknown storage engine 'InnoDB' |