| 1 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 2 |
SELECT * FROM information_schema.columns |
| 3 |
WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index' |
| 4 |
ORDER BY table_schema, |
| 5 |
table_name COLLATE utf8_general_ci, |
| 6 |
ordinal_position; |
| 7 |
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 GENERATION_EXPRESSION SRS_ID |
| 8 |
def mysql columns_priv Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 9 |
def mysql columns_priv Db 2 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 10 |
def mysql columns_priv User 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 11 |
def mysql columns_priv Table_name 4 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 12 |
def mysql columns_priv Column_name 5 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 13 |
def mysql columns_priv Timestamp 6 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 14 |
def mysql columns_priv Column_priv 7 NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') select,insert,update,references NULL |
| 15 |
def mysql component component_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI auto_increment select,insert,update,references NULL |
| 16 |
def mysql component component_group_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 17 |
def mysql component component_urn 3 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select,insert,update,references NULL |
| 18 |
def mysql db Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 19 |
def mysql db Db 2 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 20 |
def mysql db User 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 21 |
def mysql db Select_priv 4 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 22 |
def mysql db Insert_priv 5 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 23 |
def mysql db Update_priv 6 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 24 |
def mysql db Delete_priv 7 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 25 |
def mysql db Create_priv 8 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 26 |
def mysql db Drop_priv 9 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 27 |
def mysql db Grant_priv 10 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 28 |
def mysql db References_priv 11 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 29 |
def mysql db Index_priv 12 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 30 |
def mysql db Alter_priv 13 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 31 |
def mysql db Create_tmp_table_priv 14 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 32 |
def mysql db Lock_tables_priv 15 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 33 |
def mysql db Create_view_priv 16 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 34 |
def mysql db Show_view_priv 17 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 35 |
def mysql db Create_routine_priv 18 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 36 |
def mysql db Alter_routine_priv 19 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 37 |
def mysql db Execute_priv 20 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 38 |
def mysql db Event_priv 21 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 39 |
def mysql db Trigger_priv 22 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 40 |
def mysql default_roles HOST 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 41 |
def mysql default_roles USER 2 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 42 |
def mysql default_roles DEFAULT_ROLE_HOST 3 % NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 43 |
def mysql default_roles DEFAULT_ROLE_USER 4 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 44 |
def mysql engine_cost engine_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references NULL |
| 45 |
def mysql engine_cost device_type 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int PRI select,insert,update,references NULL |
| 46 |
def mysql engine_cost cost_name 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references NULL |
| 47 |
def mysql engine_cost cost_value 4 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 48 |
def mysql engine_cost last_update 5 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 49 |
def mysql engine_cost comment 6 NULL YES varchar 1024 3072 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(1024) select,insert,update,references NULL |
| 50 |
def mysql engine_cost default_value 7 NULL YES float NULL NULL 12 NULL NULL NULL NULL float VIRTUAL GENERATED select,insert,update,references (case `cost_name` when _utf8mb4\'io_block_read_cost\' then 1.0 when _utf8mb4\'memory_block_read_cost\' then 0.25 else NULL end) NULL |
| 51 |
def mysql func name 1 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 52 |
def mysql func ret 2 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL |
| 53 |
def mysql func dl 3 NO char 128 384 NULL NULL NULL utf8mb3 utf8mb3_bin char(128) select,insert,update,references NULL |
| 54 |
def mysql func type 4 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('function','aggregate') select,insert,update,references NULL |
| 55 |
def mysql general_log event_time 1 CURRENT_TIMESTAMP(6) NO timestamp NULL NULL NULL NULL 6 NULL NULL timestamp(6) DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6) select,insert,update,references NULL |
| 56 |
def mysql general_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext select,insert,update,references NULL |
| 57 |
def mysql general_log thread_id 3 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 58 |
def mysql general_log server_id 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 59 |
def mysql general_log command_type 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select,insert,update,references NULL |
| 60 |
def mysql general_log argument 6 NULL NO mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL |
| 61 |
def mysql global_grants USER 1 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 62 |
def mysql global_grants HOST 2 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 63 |
def mysql global_grants PRIV 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(32) PRI select,insert,update,references NULL |
| 64 |
def mysql global_grants WITH_GRANT_OPTION 4 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 65 |
def mysql gtid_executed source_uuid 1 NULL NO char 36 144 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci char(36) PRI select,insert,update,references uuid of the source where the transaction was originally executed. NULL |
| 66 |
def mysql gtid_executed interval_start 2 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint PRI select,insert,update,references First number of interval. NULL |
| 67 |
def mysql gtid_executed interval_end 3 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references Last number of interval. NULL |
| 68 |
def mysql help_category help_category_id 1 NULL NO smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned PRI select,insert,update,references NULL |
| 69 |
def mysql help_category name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI select,insert,update,references NULL |
| 70 |
def mysql help_category parent_category_id 3 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 71 |
def mysql help_category url 4 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select,insert,update,references NULL |
| 72 |
def mysql help_keyword help_keyword_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 73 |
def mysql help_keyword name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI select,insert,update,references NULL |
| 74 |
def mysql help_relation help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 75 |
def mysql help_relation help_keyword_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 76 |
def mysql help_topic help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 77 |
def mysql help_topic name 2 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) UNI select,insert,update,references NULL |
| 78 |
def mysql help_topic help_category_id 3 NULL NO smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 79 |
def mysql help_topic description 4 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select,insert,update,references NULL |
| 80 |
def mysql help_topic example 5 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select,insert,update,references NULL |
| 81 |
def mysql help_topic url 6 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select,insert,update,references NULL |
| 82 |
def mysql innodb_index_stats database_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL |
| 83 |
def mysql innodb_index_stats table_name 2 NULL NO varchar 199 597 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(199) PRI select,insert,update,references NULL |
| 84 |
def mysql innodb_index_stats index_name 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL |
| 85 |
def mysql innodb_index_stats last_update 4 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 86 |
def mysql innodb_index_stats stat_name 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL |
| 87 |
def mysql innodb_index_stats stat_value 6 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 88 |
def mysql innodb_index_stats sample_size 7 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 89 |
def mysql innodb_index_stats stat_description 8 NULL NO varchar 1024 3072 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(1024) select,insert,update,references NULL |
| 90 |
def mysql innodb_table_stats database_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL |
| 91 |
def mysql innodb_table_stats table_name 2 NULL NO varchar 199 597 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(199) PRI select,insert,update,references NULL |
| 92 |
def mysql innodb_table_stats last_update 3 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 93 |
def mysql innodb_table_stats n_rows 4 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 94 |
def mysql innodb_table_stats clustered_index_size 5 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 95 |
def mysql innodb_table_stats sum_of_other_index_sizes 6 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 96 |
def mysql password_history Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 97 |
def mysql password_history User 2 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 98 |
def mysql password_history Password_timestamp 3 CURRENT_TIMESTAMP(6) NO timestamp NULL NULL NULL NULL 6 NULL NULL timestamp(6) PRI DEFAULT_GENERATED select,insert,update,references NULL |
| 99 |
def mysql password_history Password 4 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 100 |
def mysql plugin name 1 NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references NULL |
| 101 |
def mysql plugin dl 2 NO varchar 128 384 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(128) select,insert,update,references NULL |
| 102 |
def mysql procs_priv Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 103 |
def mysql procs_priv Db 2 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 104 |
def mysql procs_priv User 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 105 |
def mysql procs_priv Routine_name 4 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references NULL |
| 106 |
def mysql procs_priv Routine_type 5 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') PRI select,insert,update,references NULL |
| 107 |
def mysql procs_priv Grantor 6 NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) MUL select,insert,update,references NULL |
| 108 |
def mysql procs_priv Proc_priv 7 NO set 27 81 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant') select,insert,update,references NULL |
| 109 |
def mysql procs_priv Timestamp 8 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 110 |
def mysql proxies_priv Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 111 |
def mysql proxies_priv User 2 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 112 |
def mysql proxies_priv Proxied_host 3 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 113 |
def mysql proxies_priv Proxied_user 4 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 114 |
def mysql proxies_priv With_grant 5 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references NULL |
| 115 |
def mysql proxies_priv Grantor 6 NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) MUL select,insert,update,references NULL |
| 116 |
def mysql proxies_priv Timestamp 7 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 117 |
def mysql replication_asynchronous_connection_failover Channel_name 1 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references The replication channel name that connects source and replica. NULL |
| 118 |
def mysql replication_asynchronous_connection_failover Host 2 NULL NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references The source hostname that the replica will attempt to switch over the replication connection to in case of a failure. NULL |
| 119 |
def mysql replication_asynchronous_connection_failover Port 3 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references The source port that the replica will attempt to switch over the replication connection to in case of a failure. NULL |
| 120 |
def mysql replication_asynchronous_connection_failover Network_namespace 4 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references The source network namespace that the replica will attempt to switch over the replication connection to in case of a failure. If its value is empty, connections use the default (global) namespace. NULL |
| 121 |
def mysql replication_asynchronous_connection_failover Weight 5 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references The order in which the replica shall try to switch the connection over to when there are failures. Weight can be set to a number between 1 and 100, where 100 is the highest weight and 1 the lowest. NULL |
| 122 |
def mysql replication_asynchronous_connection_failover Managed_name 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references The name of the group which this server belongs to. NULL |
| 123 |
def mysql replication_asynchronous_connection_failover_managed Channel_name 1 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references The replication channel name that connects source and replica. NULL |
| 124 |
def mysql replication_asynchronous_connection_failover_managed Managed_name 2 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references The name of the source which needs to be managed. NULL |
| 125 |
def mysql replication_asynchronous_connection_failover_managed Managed_type 3 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references Determines the managed type. NULL |
| 126 |
def mysql replication_asynchronous_connection_failover_managed Configuration 4 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select,insert,update,references The data to help manage group. For Managed_type = GroupReplication, Configuration value should contain {"Primary_weight": 80, "Secondary_weight": 60}, so that it assigns weight=80 to PRIMARY of the group, and weight=60 for rest of the members in mysql.replication_asynchronous_connection_failover table. NULL |
| 127 |
def mysql replication_group_configuration_version name 1 NULL NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references The configuration name. NULL |
| 128 |
def mysql replication_group_configuration_version version 2 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references The version of the configuration name. NULL |
| 129 |
def mysql replication_group_member_actions name 1 NULL NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references The action name. NULL |
| 130 |
def mysql replication_group_member_actions event 2 NULL NO char 64 64 NULL NULL NULL ascii ascii_general_ci char(64) PRI select,insert,update,references The event that will trigger the action. NULL |
| 131 |
def mysql replication_group_member_actions enabled 3 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Whether the action is enabled. NULL |
| 132 |
def mysql replication_group_member_actions type 4 NULL NO char 64 64 NULL NULL NULL ascii ascii_general_ci char(64) select,insert,update,references The action type. NULL |
| 133 |
def mysql replication_group_member_actions priority 5 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references The order on which the action will be run, value between 1 and 100, lower values first. NULL |
| 134 |
def mysql replication_group_member_actions error_handling 6 NULL NO char 64 64 NULL NULL NULL ascii ascii_general_ci char(64) select,insert,update,references On errors during the action will be handled: IGNORE, CRITICAL. NULL |
| 135 |
def mysql role_edges FROM_HOST 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 136 |
def mysql role_edges FROM_USER 2 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 137 |
def mysql role_edges TO_HOST 3 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 138 |
def mysql role_edges TO_USER 4 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 139 |
def mysql role_edges WITH_ADMIN_OPTION 5 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 140 |
def mysql servers Server_name 1 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references NULL |
| 141 |
def mysql servers Host 2 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select,insert,update,references NULL |
| 142 |
def mysql servers Db 3 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 143 |
def mysql servers Username 4 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 144 |
def mysql servers Password 5 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 145 |
def mysql servers Port 6 0 NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 146 |
def mysql servers Socket 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 147 |
def mysql servers Wrapper 8 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 148 |
def mysql servers Owner 9 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select,insert,update,references NULL |
| 149 |
def mysql server_cost cost_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references NULL |
| 150 |
def mysql server_cost cost_value 2 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 151 |
def mysql server_cost last_update 3 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 152 |
def mysql server_cost comment 4 NULL YES varchar 1024 3072 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(1024) select,insert,update,references NULL |
| 153 |
def mysql server_cost default_value 5 NULL YES float NULL NULL 12 NULL NULL NULL NULL float VIRTUAL GENERATED select,insert,update,references (case `cost_name` when _utf8mb4\'disk_temptable_create_cost\' then 20.0 when _utf8mb4\'disk_temptable_row_cost\' then 0.5 when _utf8mb4\'key_compare_cost\' then 0.05 when _utf8mb4\'memory_temptable_create_cost\' then 1.0 when _utf8mb4\'memory_temptable_row_cost\' then 0.1 when _utf8mb4\'row_evaluate_cost\' then 0.1 else NULL end) NULL |
| 154 |
def mysql slave_master_info Number_of_lines 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references Number of lines in the file. NULL |
| 155 |
def mysql slave_master_info Master_log_name 2 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the master binary log currently being read from the master. NULL |
| 156 |
def mysql slave_master_info Master_log_pos 3 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references The master log position of the last read event. NULL |
| 157 |
def mysql slave_master_info Host 4 NULL YES varchar 255 255 NULL NULL NULL ascii ascii_general_ci varchar(255) select,insert,update,references The host name of the source. NULL |
| 158 |
def mysql slave_master_info User_name 5 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The user name used to connect to the master. NULL |
| 159 |
def mysql slave_master_info User_password 6 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The password used to connect to the master. NULL |
| 160 |
def mysql slave_master_info Port 7 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references The network port used to connect to the master. NULL |
| 161 |
def mysql slave_master_info Connect_retry 8 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references The period (in seconds) that the slave will wait before trying to reconnect to the master. NULL |
| 162 |
def mysql slave_master_info Enabled_ssl 9 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Indicates whether the server supports SSL connections. NULL |
| 163 |
def mysql slave_master_info Ssl_ca 10 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The file used for the Certificate Authority (CA) certificate. NULL |
| 164 |
def mysql slave_master_info Ssl_capath 11 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The path to the Certificate Authority (CA) certificates. NULL |
| 165 |
def mysql slave_master_info Ssl_cert 12 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the SSL certificate file. NULL |
| 166 |
def mysql slave_master_info Ssl_cipher 13 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the cipher in use for the SSL connection. NULL |
| 167 |
def mysql slave_master_info Ssl_key 14 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the SSL key file. NULL |
| 168 |
def mysql slave_master_info Ssl_verify_server_cert 15 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Whether to verify the server certificate. NULL |
| 169 |
def mysql slave_master_info Heartbeat 16 NULL NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 170 |
def mysql slave_master_info Bind 17 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references Displays which interface is employed when connecting to the MySQL server NULL |
| 171 |
def mysql slave_master_info Ignored_server_ids 18 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The number of server IDs to be ignored, followed by the actual server IDs NULL |
| 172 |
def mysql slave_master_info Uuid 19 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The master server uuid. NULL |
| 173 |
def mysql slave_master_info Retry_count 20 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references Number of reconnect attempts, to the master, before giving up. NULL |
| 174 |
def mysql slave_master_info Ssl_crl 21 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The file used for the Certificate Revocation List (CRL) NULL |
| 175 |
def mysql slave_master_info Ssl_crlpath 22 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The path used for Certificate Revocation List (CRL) files NULL |
| 176 |
def mysql slave_master_info Enabled_auto_position 23 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Indicates whether GTIDs will be used to retrieve events from the master. NULL |
| 177 |
def mysql slave_master_info Channel_name 24 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references The channel on which the replica is connected to a source. Used in Multisource Replication NULL |
| 178 |
def mysql slave_master_info Tls_version 25 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references Tls version NULL |
| 179 |
def mysql slave_master_info Public_key_path 26 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The file containing public key of master server. NULL |
| 180 |
def mysql slave_master_info Get_public_key 27 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Preference to get public key from master. NULL |
| 181 |
def mysql slave_master_info Network_namespace 28 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references Network namespace used for communication with the master server. NULL |
| 182 |
def mysql slave_master_info Master_compression_algorithm 29 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select,insert,update,references Compression algorithm supported for data transfer between source and replica. NULL |
| 183 |
def mysql slave_master_info Master_zstd_compression_level 30 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references Compression level associated with zstd compression algorithm. NULL |
| 184 |
def mysql slave_master_info Tls_ciphersuites 31 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references Ciphersuites used for TLS 1.3 communication with the master server. NULL |
| 185 |
def mysql slave_master_info Source_connection_auto_failover 32 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Indicates whether the channel connection failover is enabled. NULL |
| 186 |
def mysql slave_master_info Gtid_only 33 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Indicates if this channel only uses GTIDs and does not persist positions. NULL |
| 187 |
def mysql slave_relay_log_info Number_of_lines 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references Number of lines in the file or rows in the table. Used to version table definitions. NULL |
| 188 |
def mysql slave_relay_log_info Relay_log_name 2 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the current relay log file. NULL |
| 189 |
def mysql slave_relay_log_info Relay_log_pos 3 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references The relay log position of the last executed event. NULL |
| 190 |
def mysql slave_relay_log_info Master_log_name 4 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references The name of the master binary log file from which the events in the relay log file were read. NULL |
| 191 |
def mysql slave_relay_log_info Master_log_pos 5 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references The master log position of the last executed event. NULL |
| 192 |
def mysql slave_relay_log_info Sql_delay 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references The number of seconds that the slave must lag behind the master. NULL |
| 193 |
def mysql slave_relay_log_info Number_of_workers 7 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 194 |
def mysql slave_relay_log_info Id 8 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references Internal Id that uniquely identifies this record. NULL |
| 195 |
def mysql slave_relay_log_info Channel_name 9 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references The channel on which the replica is connected to a source. Used in Multisource Replication NULL |
| 196 |
def mysql slave_relay_log_info Privilege_checks_username 10 NULL YES varchar 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(32) select,insert,update,references Username part of PRIVILEGE_CHECKS_USER. NULL |
| 197 |
def mysql slave_relay_log_info Privilege_checks_hostname 11 NULL YES varchar 255 255 NULL NULL NULL ascii ascii_general_ci varchar(255) select,insert,update,references Hostname part of PRIVILEGE_CHECKS_USER. NULL |
| 198 |
def mysql slave_relay_log_info Require_row_format 12 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select,insert,update,references Indicates whether the channel shall only accept row based events. NULL |
| 199 |
def mysql slave_relay_log_info Require_table_primary_key_check 13 STREAM NO enum 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('STREAM','ON','OFF','GENERATE') select,insert,update,references Indicates what is the channel policy regarding tables without primary keys on create and alter table queries NULL |
| 200 |
def mysql slave_relay_log_info Assign_gtids_to_anonymous_transactions_type 14 OFF NO enum 5 15 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('OFF','LOCAL','UUID') select,insert,update,references Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value NULL |
| 201 |
def mysql slave_relay_log_info Assign_gtids_to_anonymous_transactions_value 15 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references Indicates the UUID used while generating GTIDs for anonymous transactions NULL |
| 202 |
def mysql slave_worker_info Id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 203 |
def mysql slave_worker_info Relay_log_name 2 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 204 |
def mysql slave_worker_info Relay_log_pos 3 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 205 |
def mysql slave_worker_info Master_log_name 4 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 206 |
def mysql slave_worker_info Master_log_pos 5 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 207 |
def mysql slave_worker_info Checkpoint_relay_log_name 6 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 208 |
def mysql slave_worker_info Checkpoint_relay_log_pos 7 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 209 |
def mysql slave_worker_info Checkpoint_master_log_name 8 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 210 |
def mysql slave_worker_info Checkpoint_master_log_pos 9 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 211 |
def mysql slave_worker_info Checkpoint_seqno 10 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 212 |
def mysql slave_worker_info Checkpoint_group_size 11 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 213 |
def mysql slave_worker_info Checkpoint_group_bitmap 12 NULL NO blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 214 |
def mysql slave_worker_info Channel_name 13 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) PRI select,insert,update,references The channel on which the replica is connected to a source. Used in Multisource Replication NULL |
| 215 |
def mysql slow_log start_time 1 CURRENT_TIMESTAMP(6) NO timestamp NULL NULL NULL NULL 6 NULL NULL timestamp(6) DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6) select,insert,update,references NULL |
| 216 |
def mysql slow_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_general_ci mediumtext select,insert,update,references NULL |
| 217 |
def mysql slow_log query_time 3 NULL NO time NULL NULL NULL NULL 6 NULL NULL time(6) select,insert,update,references NULL |
| 218 |
def mysql slow_log lock_time 4 NULL NO time NULL NULL NULL NULL 6 NULL NULL time(6) select,insert,update,references NULL |
| 219 |
def mysql slow_log rows_sent 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 220 |
def mysql slow_log rows_examined 6 NULL NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 221 |
def mysql slow_log db 7 NULL NO varchar 512 1536 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select,insert,update,references NULL |
| 222 |
def mysql slow_log last_insert_id 8 NULL NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 223 |
def mysql slow_log insert_id 9 NULL NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 224 |
def mysql slow_log server_id 10 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 225 |
def mysql slow_log sql_text 11 NULL NO mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL |
| 226 |
def mysql slow_log thread_id 12 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 227 |
def mysql tables_priv Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 228 |
def mysql tables_priv Db 2 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 229 |
def mysql tables_priv User 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 230 |
def mysql tables_priv Table_name 4 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) PRI select,insert,update,references NULL |
| 231 |
def mysql tables_priv Grantor 5 NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) MUL select,insert,update,references NULL |
| 232 |
def mysql tables_priv Timestamp 6 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 233 |
def mysql tables_priv Table_priv 7 NO set 98 294 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') select,insert,update,references NULL |
| 234 |
def mysql tables_priv Column_priv 8 NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') select,insert,update,references NULL |
| 235 |
def mysql time_zone Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI auto_increment select,insert,update,references NULL |
| 236 |
def mysql time_zone Use_leap_seconds 2 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('Y','N') select,insert,update,references NULL |
| 237 |
def mysql time_zone_leap_second Transition_time 1 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint PRI select,insert,update,references NULL |
| 238 |
def mysql time_zone_leap_second Correction 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 239 |
def mysql time_zone_name Name 1 NULL NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) PRI select,insert,update,references NULL |
| 240 |
def mysql time_zone_name Time_zone_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 241 |
def mysql time_zone_transition Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 242 |
def mysql time_zone_transition Transition_time 2 NULL NO bigint NULL NULL 19 0 NULL NULL NULL bigint PRI select,insert,update,references NULL |
| 243 |
def mysql time_zone_transition Transition_type_id 3 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 244 |
def mysql time_zone_transition_type Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 245 |
def mysql time_zone_transition_type Transition_type_id 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned PRI select,insert,update,references NULL |
| 246 |
def mysql time_zone_transition_type Offset 3 0 NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 247 |
def mysql time_zone_transition_type Is_DST 4 0 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL |
| 248 |
def mysql time_zone_transition_type Abbreviation 5 NO char 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(8) select,insert,update,references NULL |
| 249 |
def mysql user Host 1 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) PRI select,insert,update,references NULL |
| 250 |
def mysql user User 2 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) PRI select,insert,update,references NULL |
| 251 |
def mysql user Select_priv 3 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 252 |
def mysql user Insert_priv 4 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 253 |
def mysql user Update_priv 5 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 254 |
def mysql user Delete_priv 6 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 255 |
def mysql user Create_priv 7 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 256 |
def mysql user Drop_priv 8 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 257 |
def mysql user Reload_priv 9 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 258 |
def mysql user Shutdown_priv 10 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 259 |
def mysql user Process_priv 11 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 260 |
def mysql user File_priv 12 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 261 |
def mysql user Grant_priv 13 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 262 |
def mysql user References_priv 14 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 263 |
def mysql user Index_priv 15 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 264 |
def mysql user Alter_priv 16 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 265 |
def mysql user Show_db_priv 17 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 266 |
def mysql user Super_priv 18 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 267 |
def mysql user Create_tmp_table_priv 19 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 268 |
def mysql user Lock_tables_priv 20 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 269 |
def mysql user Execute_priv 21 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 270 |
def mysql user Repl_slave_priv 22 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 271 |
def mysql user Repl_client_priv 23 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 272 |
def mysql user Create_view_priv 24 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 273 |
def mysql user Show_view_priv 25 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 274 |
def mysql user Create_routine_priv 26 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 275 |
def mysql user Alter_routine_priv 27 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 276 |
def mysql user Create_user_priv 28 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 277 |
def mysql user Event_priv 29 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 278 |
def mysql user Trigger_priv 30 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 279 |
def mysql user Create_tablespace_priv 31 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 280 |
def mysql user ssl_type 32 NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('','ANY','X509','SPECIFIED') select,insert,update,references NULL |
| 281 |
def mysql user ssl_cipher 33 NULL NO blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 282 |
def mysql user x509_issuer 34 NULL NO blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 283 |
def mysql user x509_subject 35 NULL NO blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 284 |
def mysql user max_questions 36 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 285 |
def mysql user max_updates 37 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 286 |
def mysql user max_connections 38 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 287 |
def mysql user max_user_connections 39 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 288 |
def mysql user plugin 40 caching_sha2_password NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select,insert,update,references NULL |
| 289 |
def mysql user authentication_string 41 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select,insert,update,references NULL |
| 290 |
def mysql user password_expired 42 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 291 |
def mysql user password_last_changed 43 NULL YES timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL |
| 292 |
def mysql user password_lifetime 44 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 293 |
def mysql user account_locked 45 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 294 |
def mysql user Create_role_priv 46 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 295 |
def mysql user Drop_role_priv 47 N NO enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 296 |
def mysql user Password_reuse_history 48 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 297 |
def mysql user Password_reuse_time 49 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 298 |
def mysql user Password_require_current 50 NULL YES enum 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci enum('N','Y') select,insert,update,references NULL |
| 299 |
def mysql user User_attributes 51 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select,insert,update,references NULL |
| 300 |
########################################################################## |
| 301 |
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH |
| 302 |
########################################################################## |
| 303 |
SELECT DISTINCT |
| 304 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 305 |
DATA_TYPE, |
| 306 |
CHARACTER_SET_NAME, |
| 307 |
COLLATION_NAME |
| 308 |
FROM information_schema.columns |
| 309 |
WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index' |
| 310 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1 |
| 311 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 312 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 313 |
1.0000 blob NULL NULL |
| 314 |
1.0000 mediumblob NULL NULL |
| 315 |
1.0000 char ascii ascii_general_ci |
| 316 |
1.0000 varchar ascii ascii_general_ci |
| 317 |
1.0000 text utf8mb3 utf8mb3_bin |
| 318 |
1.0000 mediumtext utf8mb3 utf8mb3_general_ci |
| 319 |
1.0000 text utf8mb3 utf8mb3_general_ci |
| 320 |
SELECT DISTINCT |
| 321 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 322 |
DATA_TYPE, |
| 323 |
CHARACTER_SET_NAME, |
| 324 |
COLLATION_NAME |
| 325 |
FROM information_schema.columns |
| 326 |
WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index' |
| 327 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1 |
| 328 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 329 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 330 |
3.0000 char utf8mb3 utf8mb3_bin |
| 331 |
3.0000 enum utf8mb3 utf8mb3_bin |
| 332 |
3.0000 varchar utf8mb3 utf8mb3_bin |
| 333 |
3.0000 char utf8mb3 utf8mb3_general_ci |
| 334 |
3.0000 enum utf8mb3 utf8mb3_general_ci |
| 335 |
3.0000 set utf8mb3 utf8mb3_general_ci |
| 336 |
3.0000 varchar utf8mb3 utf8mb3_general_ci |
| 337 |
4.0000 char utf8mb4 utf8mb4_0900_ai_ci |
| 338 |
SELECT DISTINCT |
| 339 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 340 |
DATA_TYPE, |
| 341 |
CHARACTER_SET_NAME, |
| 342 |
COLLATION_NAME |
| 343 |
FROM information_schema.columns |
| 344 |
WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index' |
| 345 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL |
| 346 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 347 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 348 |
NULL bigint NULL NULL |
| 349 |
NULL float NULL NULL |
| 350 |
NULL int NULL NULL |
| 351 |
NULL json NULL NULL |
| 352 |
NULL smallint NULL NULL |
| 353 |
NULL time NULL NULL |
| 354 |
NULL timestamp NULL NULL |
| 355 |
NULL tinyint NULL NULL |
| 356 |
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values |
| 357 |
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL |
| 358 |
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 359 |
TABLE_SCHEMA, |
| 360 |
TABLE_NAME, |
| 361 |
COLUMN_NAME, |
| 362 |
DATA_TYPE, |
| 363 |
CHARACTER_MAXIMUM_LENGTH, |
| 364 |
CHARACTER_OCTET_LENGTH, |
| 365 |
CHARACTER_SET_NAME, |
| 366 |
COLLATION_NAME, |
| 367 |
COLUMN_TYPE |
| 368 |
FROM information_schema.columns |
| 369 |
WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index' |
| 370 |
ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION; |
| 371 |
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE |
| 372 |
1.0000 mysql columns_priv Host char 255 255 ascii ascii_general_ci char(255) |
| 373 |
3.0000 mysql columns_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 374 |
3.0000 mysql columns_priv User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 375 |
3.0000 mysql columns_priv Table_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 376 |
3.0000 mysql columns_priv Column_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 377 |
NULL mysql columns_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 378 |
3.0000 mysql columns_priv Column_priv set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') |
| 379 |
NULL mysql component component_id int NULL NULL NULL NULL int unsigned |
| 380 |
NULL mysql component component_group_id int NULL NULL NULL NULL int unsigned |
| 381 |
1.0000 mysql component component_urn text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 382 |
1.0000 mysql db Host char 255 255 ascii ascii_general_ci char(255) |
| 383 |
3.0000 mysql db Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 384 |
3.0000 mysql db User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 385 |
3.0000 mysql db Select_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 386 |
3.0000 mysql db Insert_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 387 |
3.0000 mysql db Update_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 388 |
3.0000 mysql db Delete_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 389 |
3.0000 mysql db Create_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 390 |
3.0000 mysql db Drop_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 391 |
3.0000 mysql db Grant_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 392 |
3.0000 mysql db References_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 393 |
3.0000 mysql db Index_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 394 |
3.0000 mysql db Alter_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 395 |
3.0000 mysql db Create_tmp_table_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 396 |
3.0000 mysql db Lock_tables_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 397 |
3.0000 mysql db Create_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 398 |
3.0000 mysql db Show_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 399 |
3.0000 mysql db Create_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 400 |
3.0000 mysql db Alter_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 401 |
3.0000 mysql db Execute_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 402 |
3.0000 mysql db Event_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 403 |
3.0000 mysql db Trigger_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 404 |
1.0000 mysql default_roles HOST char 255 255 ascii ascii_general_ci char(255) |
| 405 |
3.0000 mysql default_roles USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 406 |
1.0000 mysql default_roles DEFAULT_ROLE_HOST char 255 255 ascii ascii_general_ci char(255) |
| 407 |
3.0000 mysql default_roles DEFAULT_ROLE_USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 408 |
3.0000 mysql engine_cost engine_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 409 |
NULL mysql engine_cost device_type int NULL NULL NULL NULL int |
| 410 |
3.0000 mysql engine_cost cost_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 411 |
NULL mysql engine_cost cost_value float NULL NULL NULL NULL float |
| 412 |
NULL mysql engine_cost last_update timestamp NULL NULL NULL NULL timestamp |
| 413 |
3.0000 mysql engine_cost comment varchar 1024 3072 utf8mb3 utf8mb3_general_ci varchar(1024) |
| 414 |
NULL mysql engine_cost default_value float NULL NULL NULL NULL float |
| 415 |
3.0000 mysql func name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 416 |
NULL mysql func ret tinyint NULL NULL NULL NULL tinyint |
| 417 |
3.0000 mysql func dl char 128 384 utf8mb3 utf8mb3_bin char(128) |
| 418 |
3.0000 mysql func type enum 9 27 utf8mb3 utf8mb3_general_ci enum('function','aggregate') |
| 419 |
NULL mysql general_log event_time timestamp NULL NULL NULL NULL timestamp(6) |
| 420 |
1.0000 mysql general_log user_host mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 421 |
NULL mysql general_log thread_id bigint NULL NULL NULL NULL bigint unsigned |
| 422 |
NULL mysql general_log server_id int NULL NULL NULL NULL int unsigned |
| 423 |
3.0000 mysql general_log command_type varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 424 |
1.0000 mysql general_log argument mediumblob 16777215 16777215 NULL NULL mediumblob |
| 425 |
3.0000 mysql global_grants USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 426 |
1.0000 mysql global_grants HOST char 255 255 ascii ascii_general_ci char(255) |
| 427 |
3.0000 mysql global_grants PRIV char 32 96 utf8mb3 utf8mb3_general_ci char(32) |
| 428 |
3.0000 mysql global_grants WITH_GRANT_OPTION enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 429 |
4.0000 mysql gtid_executed source_uuid char 36 144 utf8mb4 utf8mb4_0900_ai_ci char(36) |
| 430 |
NULL mysql gtid_executed interval_start bigint NULL NULL NULL NULL bigint |
| 431 |
NULL mysql gtid_executed interval_end bigint NULL NULL NULL NULL bigint |
| 432 |
NULL mysql help_category help_category_id smallint NULL NULL NULL NULL smallint unsigned |
| 433 |
3.0000 mysql help_category name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 434 |
NULL mysql help_category parent_category_id smallint NULL NULL NULL NULL smallint unsigned |
| 435 |
1.0000 mysql help_category url text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 436 |
NULL mysql help_keyword help_keyword_id int NULL NULL NULL NULL int unsigned |
| 437 |
3.0000 mysql help_keyword name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 438 |
NULL mysql help_relation help_topic_id int NULL NULL NULL NULL int unsigned |
| 439 |
NULL mysql help_relation help_keyword_id int NULL NULL NULL NULL int unsigned |
| 440 |
NULL mysql help_topic help_topic_id int NULL NULL NULL NULL int unsigned |
| 441 |
3.0000 mysql help_topic name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 442 |
NULL mysql help_topic help_category_id smallint NULL NULL NULL NULL smallint unsigned |
| 443 |
1.0000 mysql help_topic description text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 444 |
1.0000 mysql help_topic example text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 445 |
1.0000 mysql help_topic url text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 446 |
3.0000 mysql innodb_index_stats database_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 447 |
3.0000 mysql innodb_index_stats table_name varchar 199 597 utf8mb3 utf8mb3_bin varchar(199) |
| 448 |
3.0000 mysql innodb_index_stats index_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 449 |
NULL mysql innodb_index_stats last_update timestamp NULL NULL NULL NULL timestamp |
| 450 |
3.0000 mysql innodb_index_stats stat_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 451 |
NULL mysql innodb_index_stats stat_value bigint NULL NULL NULL NULL bigint unsigned |
| 452 |
NULL mysql innodb_index_stats sample_size bigint NULL NULL NULL NULL bigint unsigned |
| 453 |
3.0000 mysql innodb_index_stats stat_description varchar 1024 3072 utf8mb3 utf8mb3_bin varchar(1024) |
| 454 |
3.0000 mysql innodb_table_stats database_name varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 455 |
3.0000 mysql innodb_table_stats table_name varchar 199 597 utf8mb3 utf8mb3_bin varchar(199) |
| 456 |
NULL mysql innodb_table_stats last_update timestamp NULL NULL NULL NULL timestamp |
| 457 |
NULL mysql innodb_table_stats n_rows bigint NULL NULL NULL NULL bigint unsigned |
| 458 |
NULL mysql innodb_table_stats clustered_index_size bigint NULL NULL NULL NULL bigint unsigned |
| 459 |
NULL mysql innodb_table_stats sum_of_other_index_sizes bigint NULL NULL NULL NULL bigint unsigned |
| 460 |
1.0000 mysql password_history Host char 255 255 ascii ascii_general_ci char(255) |
| 461 |
3.0000 mysql password_history User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 462 |
NULL mysql password_history Password_timestamp timestamp NULL NULL NULL NULL timestamp(6) |
| 463 |
1.0000 mysql password_history Password text 65535 65535 utf8mb3 utf8mb3_bin text |
| 464 |
3.0000 mysql plugin name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 465 |
3.0000 mysql plugin dl varchar 128 384 utf8mb3 utf8mb3_general_ci varchar(128) |
| 466 |
1.0000 mysql procs_priv Host char 255 255 ascii ascii_general_ci char(255) |
| 467 |
3.0000 mysql procs_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 468 |
3.0000 mysql procs_priv User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 469 |
3.0000 mysql procs_priv Routine_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 470 |
3.0000 mysql procs_priv Routine_type enum 9 27 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') |
| 471 |
3.0000 mysql procs_priv Grantor varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 472 |
3.0000 mysql procs_priv Proc_priv set 27 81 utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant') |
| 473 |
NULL mysql procs_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 474 |
1.0000 mysql proxies_priv Host char 255 255 ascii ascii_general_ci char(255) |
| 475 |
3.0000 mysql proxies_priv User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 476 |
1.0000 mysql proxies_priv Proxied_host char 255 255 ascii ascii_general_ci char(255) |
| 477 |
3.0000 mysql proxies_priv Proxied_user char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 478 |
NULL mysql proxies_priv With_grant tinyint NULL NULL NULL NULL tinyint(1) |
| 479 |
3.0000 mysql proxies_priv Grantor varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 480 |
NULL mysql proxies_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 481 |
3.0000 mysql replication_asynchronous_connection_failover Channel_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 482 |
1.0000 mysql replication_asynchronous_connection_failover Host char 255 255 ascii ascii_general_ci char(255) |
| 483 |
NULL mysql replication_asynchronous_connection_failover Port int NULL NULL NULL NULL int unsigned |
| 484 |
3.0000 mysql replication_asynchronous_connection_failover Network_namespace char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 485 |
NULL mysql replication_asynchronous_connection_failover Weight tinyint NULL NULL NULL NULL tinyint unsigned |
| 486 |
3.0000 mysql replication_asynchronous_connection_failover Managed_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 487 |
3.0000 mysql replication_asynchronous_connection_failover_managed Channel_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 488 |
3.0000 mysql replication_asynchronous_connection_failover_managed Managed_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 489 |
3.0000 mysql replication_asynchronous_connection_failover_managed Managed_type char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 490 |
NULL mysql replication_asynchronous_connection_failover_managed Configuration json NULL NULL NULL NULL json |
| 491 |
1.0000 mysql replication_group_configuration_version name char 255 255 ascii ascii_general_ci char(255) |
| 492 |
NULL mysql replication_group_configuration_version version bigint NULL NULL NULL NULL bigint unsigned |
| 493 |
1.0000 mysql replication_group_member_actions name char 255 255 ascii ascii_general_ci char(255) |
| 494 |
1.0000 mysql replication_group_member_actions event char 64 64 ascii ascii_general_ci char(64) |
| 495 |
NULL mysql replication_group_member_actions enabled tinyint NULL NULL NULL NULL tinyint(1) |
| 496 |
1.0000 mysql replication_group_member_actions type char 64 64 ascii ascii_general_ci char(64) |
| 497 |
NULL mysql replication_group_member_actions priority tinyint NULL NULL NULL NULL tinyint unsigned |
| 498 |
1.0000 mysql replication_group_member_actions error_handling char 64 64 ascii ascii_general_ci char(64) |
| 499 |
1.0000 mysql role_edges FROM_HOST char 255 255 ascii ascii_general_ci char(255) |
| 500 |
3.0000 mysql role_edges FROM_USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 501 |
1.0000 mysql role_edges TO_HOST char 255 255 ascii ascii_general_ci char(255) |
| 502 |
3.0000 mysql role_edges TO_USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 503 |
3.0000 mysql role_edges WITH_ADMIN_OPTION enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 504 |
3.0000 mysql servers Server_name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 505 |
1.0000 mysql servers Host char 255 255 ascii ascii_general_ci char(255) |
| 506 |
3.0000 mysql servers Db char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 507 |
3.0000 mysql servers Username char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 508 |
3.0000 mysql servers Password char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 509 |
NULL mysql servers Port int NULL NULL NULL NULL int |
| 510 |
3.0000 mysql servers Socket char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 511 |
3.0000 mysql servers Wrapper char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 512 |
3.0000 mysql servers Owner char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 513 |
3.0000 mysql server_cost cost_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 514 |
NULL mysql server_cost cost_value float NULL NULL NULL NULL float |
| 515 |
NULL mysql server_cost last_update timestamp NULL NULL NULL NULL timestamp |
| 516 |
3.0000 mysql server_cost comment varchar 1024 3072 utf8mb3 utf8mb3_general_ci varchar(1024) |
| 517 |
NULL mysql server_cost default_value float NULL NULL NULL NULL float |
| 518 |
NULL mysql slave_master_info Number_of_lines int NULL NULL NULL NULL int unsigned |
| 519 |
1.0000 mysql slave_master_info Master_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 520 |
NULL mysql slave_master_info Master_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 521 |
1.0000 mysql slave_master_info Host varchar 255 255 ascii ascii_general_ci varchar(255) |
| 522 |
1.0000 mysql slave_master_info User_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 523 |
1.0000 mysql slave_master_info User_password text 65535 65535 utf8mb3 utf8mb3_bin text |
| 524 |
NULL mysql slave_master_info Port int NULL NULL NULL NULL int unsigned |
| 525 |
NULL mysql slave_master_info Connect_retry int NULL NULL NULL NULL int unsigned |
| 526 |
NULL mysql slave_master_info Enabled_ssl tinyint NULL NULL NULL NULL tinyint(1) |
| 527 |
1.0000 mysql slave_master_info Ssl_ca text 65535 65535 utf8mb3 utf8mb3_bin text |
| 528 |
1.0000 mysql slave_master_info Ssl_capath text 65535 65535 utf8mb3 utf8mb3_bin text |
| 529 |
1.0000 mysql slave_master_info Ssl_cert text 65535 65535 utf8mb3 utf8mb3_bin text |
| 530 |
1.0000 mysql slave_master_info Ssl_cipher text 65535 65535 utf8mb3 utf8mb3_bin text |
| 531 |
1.0000 mysql slave_master_info Ssl_key text 65535 65535 utf8mb3 utf8mb3_bin text |
| 532 |
NULL mysql slave_master_info Ssl_verify_server_cert tinyint NULL NULL NULL NULL tinyint(1) |
| 533 |
NULL mysql slave_master_info Heartbeat float NULL NULL NULL NULL float |
| 534 |
1.0000 mysql slave_master_info Bind text 65535 65535 utf8mb3 utf8mb3_bin text |
| 535 |
1.0000 mysql slave_master_info Ignored_server_ids text 65535 65535 utf8mb3 utf8mb3_bin text |
| 536 |
1.0000 mysql slave_master_info Uuid text 65535 65535 utf8mb3 utf8mb3_bin text |
| 537 |
NULL mysql slave_master_info Retry_count bigint NULL NULL NULL NULL bigint unsigned |
| 538 |
1.0000 mysql slave_master_info Ssl_crl text 65535 65535 utf8mb3 utf8mb3_bin text |
| 539 |
1.0000 mysql slave_master_info Ssl_crlpath text 65535 65535 utf8mb3 utf8mb3_bin text |
| 540 |
NULL mysql slave_master_info Enabled_auto_position tinyint NULL NULL NULL NULL tinyint(1) |
| 541 |
3.0000 mysql slave_master_info Channel_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 542 |
1.0000 mysql slave_master_info Tls_version text 65535 65535 utf8mb3 utf8mb3_bin text |
| 543 |
1.0000 mysql slave_master_info Public_key_path text 65535 65535 utf8mb3 utf8mb3_bin text |
| 544 |
NULL mysql slave_master_info Get_public_key tinyint NULL NULL NULL NULL tinyint(1) |
| 545 |
1.0000 mysql slave_master_info Network_namespace text 65535 65535 utf8mb3 utf8mb3_bin text |
| 546 |
3.0000 mysql slave_master_info Master_compression_algorithm varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 547 |
NULL mysql slave_master_info Master_zstd_compression_level int NULL NULL NULL NULL int unsigned |
| 548 |
1.0000 mysql slave_master_info Tls_ciphersuites text 65535 65535 utf8mb3 utf8mb3_bin text |
| 549 |
NULL mysql slave_master_info Source_connection_auto_failover tinyint NULL NULL NULL NULL tinyint(1) |
| 550 |
NULL mysql slave_master_info Gtid_only tinyint NULL NULL NULL NULL tinyint(1) |
| 551 |
NULL mysql slave_relay_log_info Number_of_lines int NULL NULL NULL NULL int unsigned |
| 552 |
1.0000 mysql slave_relay_log_info Relay_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 553 |
NULL mysql slave_relay_log_info Relay_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 554 |
1.0000 mysql slave_relay_log_info Master_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 555 |
NULL mysql slave_relay_log_info Master_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 556 |
NULL mysql slave_relay_log_info Sql_delay int NULL NULL NULL NULL int |
| 557 |
NULL mysql slave_relay_log_info Number_of_workers int NULL NULL NULL NULL int unsigned |
| 558 |
NULL mysql slave_relay_log_info Id int NULL NULL NULL NULL int unsigned |
| 559 |
3.0000 mysql slave_relay_log_info Channel_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 560 |
3.0000 mysql slave_relay_log_info Privilege_checks_username varchar 32 96 utf8mb3 utf8mb3_bin varchar(32) |
| 561 |
1.0000 mysql slave_relay_log_info Privilege_checks_hostname varchar 255 255 ascii ascii_general_ci varchar(255) |
| 562 |
NULL mysql slave_relay_log_info Require_row_format tinyint NULL NULL NULL NULL tinyint(1) |
| 563 |
3.0000 mysql slave_relay_log_info Require_table_primary_key_check enum 8 24 utf8mb3 utf8mb3_general_ci enum('STREAM','ON','OFF','GENERATE') |
| 564 |
3.0000 mysql slave_relay_log_info Assign_gtids_to_anonymous_transactions_type enum 5 15 utf8mb3 utf8mb3_general_ci enum('OFF','LOCAL','UUID') |
| 565 |
1.0000 mysql slave_relay_log_info Assign_gtids_to_anonymous_transactions_value text 65535 65535 utf8mb3 utf8mb3_bin text |
| 566 |
NULL mysql slave_worker_info Id int NULL NULL NULL NULL int unsigned |
| 567 |
1.0000 mysql slave_worker_info Relay_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 568 |
NULL mysql slave_worker_info Relay_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 569 |
1.0000 mysql slave_worker_info Master_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 570 |
NULL mysql slave_worker_info Master_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 571 |
1.0000 mysql slave_worker_info Checkpoint_relay_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 572 |
NULL mysql slave_worker_info Checkpoint_relay_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 573 |
1.0000 mysql slave_worker_info Checkpoint_master_log_name text 65535 65535 utf8mb3 utf8mb3_bin text |
| 574 |
NULL mysql slave_worker_info Checkpoint_master_log_pos bigint NULL NULL NULL NULL bigint unsigned |
| 575 |
NULL mysql slave_worker_info Checkpoint_seqno int NULL NULL NULL NULL int unsigned |
| 576 |
NULL mysql slave_worker_info Checkpoint_group_size int NULL NULL NULL NULL int unsigned |
| 577 |
1.0000 mysql slave_worker_info Checkpoint_group_bitmap blob 65535 65535 NULL NULL blob |
| 578 |
3.0000 mysql slave_worker_info Channel_name varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 579 |
NULL mysql slow_log start_time timestamp NULL NULL NULL NULL timestamp(6) |
| 580 |
1.0000 mysql slow_log user_host mediumtext 16777215 16777215 utf8mb3 utf8mb3_general_ci mediumtext |
| 581 |
NULL mysql slow_log query_time time NULL NULL NULL NULL time(6) |
| 582 |
NULL mysql slow_log lock_time time NULL NULL NULL NULL time(6) |
| 583 |
NULL mysql slow_log rows_sent int NULL NULL NULL NULL int |
| 584 |
NULL mysql slow_log rows_examined int NULL NULL NULL NULL int |
| 585 |
3.0000 mysql slow_log db varchar 512 1536 utf8mb3 utf8mb3_general_ci varchar(512) |
| 586 |
NULL mysql slow_log last_insert_id int NULL NULL NULL NULL int |
| 587 |
NULL mysql slow_log insert_id int NULL NULL NULL NULL int |
| 588 |
NULL mysql slow_log server_id int NULL NULL NULL NULL int unsigned |
| 589 |
1.0000 mysql slow_log sql_text mediumblob 16777215 16777215 NULL NULL mediumblob |
| 590 |
NULL mysql slow_log thread_id bigint NULL NULL NULL NULL bigint unsigned |
| 591 |
1.0000 mysql tables_priv Host char 255 255 ascii ascii_general_ci char(255) |
| 592 |
3.0000 mysql tables_priv Db char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 593 |
3.0000 mysql tables_priv User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 594 |
3.0000 mysql tables_priv Table_name char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 595 |
3.0000 mysql tables_priv Grantor varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 596 |
NULL mysql tables_priv Timestamp timestamp NULL NULL NULL NULL timestamp |
| 597 |
3.0000 mysql tables_priv Table_priv set 98 294 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') |
| 598 |
3.0000 mysql tables_priv Column_priv set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') |
| 599 |
NULL mysql time_zone Time_zone_id int NULL NULL NULL NULL int unsigned |
| 600 |
3.0000 mysql time_zone Use_leap_seconds enum 1 3 utf8mb3 utf8mb3_general_ci enum('Y','N') |
| 601 |
NULL mysql time_zone_leap_second Transition_time bigint NULL NULL NULL NULL bigint |
| 602 |
NULL mysql time_zone_leap_second Correction int NULL NULL NULL NULL int |
| 603 |
3.0000 mysql time_zone_name Name char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 604 |
NULL mysql time_zone_name Time_zone_id int NULL NULL NULL NULL int unsigned |
| 605 |
NULL mysql time_zone_transition Time_zone_id int NULL NULL NULL NULL int unsigned |
| 606 |
NULL mysql time_zone_transition Transition_time bigint NULL NULL NULL NULL bigint |
| 607 |
NULL mysql time_zone_transition Transition_type_id int NULL NULL NULL NULL int unsigned |
| 608 |
NULL mysql time_zone_transition_type Time_zone_id int NULL NULL NULL NULL int unsigned |
| 609 |
NULL mysql time_zone_transition_type Transition_type_id int NULL NULL NULL NULL int unsigned |
| 610 |
NULL mysql time_zone_transition_type Offset int NULL NULL NULL NULL int |
| 611 |
NULL mysql time_zone_transition_type Is_DST tinyint NULL NULL NULL NULL tinyint unsigned |
| 612 |
3.0000 mysql time_zone_transition_type Abbreviation char 8 24 utf8mb3 utf8mb3_general_ci char(8) |
| 613 |
1.0000 mysql user Host char 255 255 ascii ascii_general_ci char(255) |
| 614 |
3.0000 mysql user User char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 615 |
3.0000 mysql user Select_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 616 |
3.0000 mysql user Insert_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 617 |
3.0000 mysql user Update_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 618 |
3.0000 mysql user Delete_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 619 |
3.0000 mysql user Create_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 620 |
3.0000 mysql user Drop_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 621 |
3.0000 mysql user Reload_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 622 |
3.0000 mysql user Shutdown_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 623 |
3.0000 mysql user Process_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 624 |
3.0000 mysql user File_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 625 |
3.0000 mysql user Grant_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 626 |
3.0000 mysql user References_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 627 |
3.0000 mysql user Index_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 628 |
3.0000 mysql user Alter_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 629 |
3.0000 mysql user Show_db_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 630 |
3.0000 mysql user Super_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 631 |
3.0000 mysql user Create_tmp_table_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 632 |
3.0000 mysql user Lock_tables_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 633 |
3.0000 mysql user Execute_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 634 |
3.0000 mysql user Repl_slave_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 635 |
3.0000 mysql user Repl_client_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 636 |
3.0000 mysql user Create_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 637 |
3.0000 mysql user Show_view_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 638 |
3.0000 mysql user Create_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 639 |
3.0000 mysql user Alter_routine_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 640 |
3.0000 mysql user Create_user_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 641 |
3.0000 mysql user Event_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 642 |
3.0000 mysql user Trigger_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 643 |
3.0000 mysql user Create_tablespace_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 644 |
3.0000 mysql user ssl_type enum 9 27 utf8mb3 utf8mb3_general_ci enum('','ANY','X509','SPECIFIED') |
| 645 |
1.0000 mysql user ssl_cipher blob 65535 65535 NULL NULL blob |
| 646 |
1.0000 mysql user x509_issuer blob 65535 65535 NULL NULL blob |
| 647 |
1.0000 mysql user x509_subject blob 65535 65535 NULL NULL blob |
| 648 |
NULL mysql user max_questions int NULL NULL NULL NULL int unsigned |
| 649 |
NULL mysql user max_updates int NULL NULL NULL NULL int unsigned |
| 650 |
NULL mysql user max_connections int NULL NULL NULL NULL int unsigned |
| 651 |
NULL mysql user max_user_connections int NULL NULL NULL NULL int unsigned |
| 652 |
3.0000 mysql user plugin char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 653 |
1.0000 mysql user authentication_string text 65535 65535 utf8mb3 utf8mb3_bin text |
| 654 |
3.0000 mysql user password_expired enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 655 |
NULL mysql user password_last_changed timestamp NULL NULL NULL NULL timestamp |
| 656 |
NULL mysql user password_lifetime smallint NULL NULL NULL NULL smallint unsigned |
| 657 |
3.0000 mysql user account_locked enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 658 |
3.0000 mysql user Create_role_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 659 |
3.0000 mysql user Drop_role_priv enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 660 |
NULL mysql user Password_reuse_history smallint NULL NULL NULL NULL smallint unsigned |
| 661 |
NULL mysql user Password_reuse_time smallint NULL NULL NULL NULL smallint unsigned |
| 662 |
3.0000 mysql user Password_require_current enum 1 3 utf8mb3 utf8mb3_general_ci enum('N','Y') |
| 663 |
NULL mysql user User_attributes json NULL NULL NULL NULL json |
| 664 |
SET sql_mode = default; |