Debian Codegraph @

mysql-test/suite/funcs_1/r/is_columns_is_cs.result

raw
1 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 SELECT * FROM information_schema.columns
3 WHERE table_schema = 'information_schema'
4 AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%'
5 ORDER BY table_schema,
6 table_name COLLATE utf8_general_ci,
7 ordinal_position;
8 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
9 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS USER 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL
10 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
11 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE 3 NULL YES varchar 97 388 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(97) select NULL
12 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE_HOST 4 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL
13 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_NAME 5 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
14 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_HOST 6 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL
15 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_GRANTABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
16 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_DEFAULT 8 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
17 def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_MANDATORY 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
18 def information_schema APPLICABLE_ROLES USER 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL
19 def information_schema APPLICABLE_ROLES HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
20 def information_schema APPLICABLE_ROLES GRANTEE 3 NULL YES varchar 97 388 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(97) select NULL
21 def information_schema APPLICABLE_ROLES GRANTEE_HOST 4 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL
22 def information_schema APPLICABLE_ROLES ROLE_NAME 5 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
23 def information_schema APPLICABLE_ROLES ROLE_HOST 6 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL
24 def information_schema APPLICABLE_ROLES IS_GRANTABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
25 def information_schema APPLICABLE_ROLES IS_DEFAULT 8 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
26 def information_schema APPLICABLE_ROLES IS_MANDATORY 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
27 def information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
28 def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
29 def information_schema CHARACTER_SETS DESCRIPTION 3 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) select NULL
30 def information_schema CHARACTER_SETS MAXLEN 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
31 def information_schema CHECK_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
32 def information_schema CHECK_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
33 def information_schema CHECK_CONSTRAINTS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
34 def information_schema CHECK_CONSTRAINTS CHECK_CLAUSE 4 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
35 def information_schema COLLATIONS COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
36 def information_schema COLLATIONS CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
37 def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
38 def information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
39 def information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
40 def information_schema COLLATIONS SORTLEN 6 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
41 def information_schema COLLATIONS PAD_ATTRIBUTE 7 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('PAD SPACE','NO PAD') select NULL
42 def information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
43 def information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
44 def information_schema COLUMNS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
45 def information_schema COLUMNS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
46 def information_schema COLUMNS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
47 def information_schema COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
48 def information_schema COLUMNS ORDINAL_POSITION 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
49 def information_schema COLUMNS COLUMN_DEFAULT 6 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
50 def information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
51 def information_schema COLUMNS DATA_TYPE 8 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
52 def information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
53 def information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
54 def information_schema COLUMNS NUMERIC_PRECISION 11 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
55 def information_schema COLUMNS NUMERIC_SCALE 12 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
56 def information_schema COLUMNS DATETIME_PRECISION 13 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
57 def information_schema COLUMNS CHARACTER_SET_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
58 def information_schema COLUMNS COLLATION_NAME 15 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
59 def information_schema COLUMNS COLUMN_TYPE 16 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL
60 def information_schema COLUMNS COLUMN_KEY 17 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('','PRI','UNI','MUL') select NULL
61 def information_schema COLUMNS EXTRA 18 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
62 def information_schema COLUMNS PRIVILEGES 19 NULL YES varchar 154 462 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(154) select NULL
63 def information_schema COLUMNS COLUMN_COMMENT 20 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
64 def information_schema COLUMNS GENERATION_EXPRESSION 21 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
65 def information_schema COLUMNS SRS_ID 22 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
66 def information_schema COLUMNS_EXTENSIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
67 def information_schema COLUMNS_EXTENSIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
68 def information_schema COLUMNS_EXTENSIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
69 def information_schema COLUMNS_EXTENSIONS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
70 def information_schema COLUMNS_EXTENSIONS ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
71 def information_schema COLUMNS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 6 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
72 def information_schema COLUMN_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL
73 def information_schema COLUMN_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL
74 def information_schema COLUMN_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
75 def information_schema COLUMN_PRIVILEGES TABLE_NAME 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
76 def information_schema COLUMN_PRIVILEGES COLUMN_NAME 5 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
77 def information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE 6 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
78 def information_schema COLUMN_PRIVILEGES IS_GRANTABLE 7 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
79 def information_schema COLUMN_STATISTICS SCHEMA_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
80 def information_schema COLUMN_STATISTICS TABLE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
81 def information_schema COLUMN_STATISTICS COLUMN_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
82 def information_schema COLUMN_STATISTICS HISTOGRAM 4 NULL NO json NULL NULL NULL NULL NULL NULL NULL json select NULL
83 def information_schema ENABLED_ROLES ROLE_NAME 1 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
84 def information_schema ENABLED_ROLES ROLE_HOST 2 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
85 def information_schema ENABLED_ROLES IS_DEFAULT 3 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
86 def information_schema ENABLED_ROLES IS_MANDATORY 4 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
87 def information_schema ENGINES ENGINE 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
88 def information_schema ENGINES SUPPORT 2 NO varchar 2 8 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL
89 def information_schema ENGINES COMMENT 3 NO varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
90 def information_schema ENGINES TRANSACTIONS 4 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
91 def information_schema ENGINES XA 5 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
92 def information_schema ENGINES SAVEPOINTS 6 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
93 def information_schema EVENTS EVENT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
94 def information_schema EVENTS EVENT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
95 def information_schema EVENTS EVENT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
96 def information_schema EVENTS DEFINER 4 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
97 def information_schema EVENTS TIME_ZONE 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
98 def information_schema EVENTS EVENT_BODY 6 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
99 def information_schema EVENTS EVENT_DEFINITION 7 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
100 def information_schema EVENTS EVENT_TYPE 8 NO varchar 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(9) select NULL
101 def information_schema EVENTS EXECUTE_AT 9 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
102 def information_schema EVENTS INTERVAL_VALUE 10 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
103 def information_schema EVENTS INTERVAL_FIELD 11 NULL YES enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_bin 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') select NULL
104 def information_schema EVENTS SQL_MODE 12 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL
105 def information_schema EVENTS STARTS 13 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
106 def information_schema EVENTS ENDS 14 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
107 def information_schema EVENTS STATUS 15 NULL NO enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_bin enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') select NULL
108 def information_schema EVENTS ON_COMPLETION 16 NO varchar 12 36 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(12) select NULL
109 def information_schema EVENTS CREATED 17 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
110 def information_schema EVENTS LAST_ALTERED 18 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
111 def information_schema EVENTS LAST_EXECUTED 19 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
112 def information_schema EVENTS EVENT_COMMENT 20 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
113 def information_schema EVENTS ORIGINATOR 21 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
114 def information_schema EVENTS CHARACTER_SET_CLIENT 22 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
115 def information_schema EVENTS COLLATION_CONNECTION 23 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
116 def information_schema EVENTS DATABASE_COLLATION 24 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
117 def information_schema FILES FILE_ID 1 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
118 def information_schema FILES FILE_NAME 2 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
119 def information_schema FILES FILE_TYPE 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
120 def information_schema FILES TABLESPACE_NAME 4 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
121 def information_schema FILES TABLE_CATALOG 5 NO char 0 0 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(0) select NULL
122 def information_schema FILES TABLE_SCHEMA 6 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
123 def information_schema FILES TABLE_NAME 7 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
124 def information_schema FILES LOGFILE_GROUP_NAME 8 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
125 def information_schema FILES LOGFILE_GROUP_NUMBER 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
126 def information_schema FILES ENGINE 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
127 def information_schema FILES FULLTEXT_KEYS 11 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
128 def information_schema FILES DELETED_ROWS 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
129 def information_schema FILES UPDATE_COUNT 13 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
130 def information_schema FILES FREE_EXTENTS 14 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
131 def information_schema FILES TOTAL_EXTENTS 15 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
132 def information_schema FILES EXTENT_SIZE 16 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
133 def information_schema FILES INITIAL_SIZE 17 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
134 def information_schema FILES MAXIMUM_SIZE 18 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
135 def information_schema FILES AUTOEXTEND_SIZE 19 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
136 def information_schema FILES CREATION_TIME 20 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
137 def information_schema FILES LAST_UPDATE_TIME 21 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
138 def information_schema FILES LAST_ACCESS_TIME 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
139 def information_schema FILES RECOVER_TIME 23 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
140 def information_schema FILES TRANSACTION_COUNTER 24 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
141 def information_schema FILES VERSION 25 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
142 def information_schema FILES ROW_FORMAT 26 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
143 def information_schema FILES TABLE_ROWS 27 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
144 def information_schema FILES AVG_ROW_LENGTH 28 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
145 def information_schema FILES DATA_LENGTH 29 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
146 def information_schema FILES MAX_DATA_LENGTH 30 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
147 def information_schema FILES INDEX_LENGTH 31 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
148 def information_schema FILES DATA_FREE 32 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
149 def information_schema FILES CREATE_TIME 33 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
150 def information_schema FILES UPDATE_TIME 34 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
151 def information_schema FILES CHECK_TIME 35 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
152 def information_schema FILES CHECKSUM 36 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
153 def information_schema FILES STATUS 37 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
154 def information_schema FILES EXTRA 38 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
155 def information_schema KEYWORDS WORD 1 NULL YES varchar 128 512 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(128) select NULL
156 def information_schema KEYWORDS RESERVED 2 NULL YES int NULL NULL 10 0 NULL NULL NULL int select NULL
157 def information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
158 def information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
159 def information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
160 def information_schema KEY_COLUMN_USAGE TABLE_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
161 def information_schema KEY_COLUMN_USAGE TABLE_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
162 def information_schema KEY_COLUMN_USAGE TABLE_NAME 6 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
163 def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
164 def information_schema KEY_COLUMN_USAGE ORDINAL_POSITION 8 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
165 def information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
166 def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA 10 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
167 def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME 11 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
168 def information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
169 def information_schema OPTIMIZER_TRACE QUERY 1 NO varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL
170 def information_schema OPTIMIZER_TRACE TRACE 2 NO varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL
171 def information_schema OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE 3 NO int NULL NULL NULL NULL NULL NULL NULL int select NULL
172 def information_schema OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES 4 NO tinyint NULL NULL NULL NULL NULL NULL NULL tinyint(1) select NULL
173 def information_schema PARAMETERS SPECIFIC_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
174 def information_schema PARAMETERS SPECIFIC_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
175 def information_schema PARAMETERS SPECIFIC_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
176 def information_schema PARAMETERS ORDINAL_POSITION 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
177 def information_schema PARAMETERS PARAMETER_MODE 5 NULL YES varchar 5 15 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(5) select NULL
178 def information_schema PARAMETERS PARAMETER_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
179 def information_schema PARAMETERS DATA_TYPE 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
180 def information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
181 def information_schema PARAMETERS CHARACTER_OCTET_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
182 def information_schema PARAMETERS NUMERIC_PRECISION 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
183 def information_schema PARAMETERS NUMERIC_SCALE 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
184 def information_schema PARAMETERS DATETIME_PRECISION 12 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
185 def information_schema PARAMETERS CHARACTER_SET_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
186 def information_schema PARAMETERS COLLATION_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
187 def information_schema PARAMETERS DTD_IDENTIFIER 15 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL
188 def information_schema PARAMETERS ROUTINE_TYPE 16 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL
189 def information_schema PARTITIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
190 def information_schema PARTITIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
191 def information_schema PARTITIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
192 def information_schema PARTITIONS PARTITION_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
193 def information_schema PARTITIONS SUBPARTITION_NAME 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
194 def information_schema PARTITIONS PARTITION_ORDINAL_POSITION 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
195 def information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION 7 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
196 def information_schema PARTITIONS PARTITION_METHOD 8 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL
197 def information_schema PARTITIONS SUBPARTITION_METHOD 9 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL
198 def information_schema PARTITIONS PARTITION_EXPRESSION 10 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
199 def information_schema PARTITIONS SUBPARTITION_EXPRESSION 11 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
200 def information_schema PARTITIONS PARTITION_DESCRIPTION 12 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
201 def information_schema PARTITIONS TABLE_ROWS 13 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
202 def information_schema PARTITIONS AVG_ROW_LENGTH 14 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
203 def information_schema PARTITIONS DATA_LENGTH 15 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
204 def information_schema PARTITIONS MAX_DATA_LENGTH 16 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
205 def information_schema PARTITIONS INDEX_LENGTH 17 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
206 def information_schema PARTITIONS DATA_FREE 18 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
207 def information_schema PARTITIONS CREATE_TIME 19 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
208 def information_schema PARTITIONS UPDATE_TIME 20 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
209 def information_schema PARTITIONS CHECK_TIME 21 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
210 def information_schema PARTITIONS CHECKSUM 22 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
211 def information_schema PARTITIONS PARTITION_COMMENT 23 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
212 def information_schema PARTITIONS NODEGROUP 24 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
213 def information_schema PARTITIONS TABLESPACE_NAME 25 NULL YES varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
214 def information_schema PLUGINS PLUGIN_NAME 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
215 def information_schema PLUGINS PLUGIN_VERSION 2 NO varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL
216 def information_schema PLUGINS PLUGIN_STATUS 3 NO varchar 3 10 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(10) select NULL
217 def information_schema PLUGINS PLUGIN_TYPE 4 NO varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
218 def information_schema PLUGINS PLUGIN_TYPE_VERSION 5 NO varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL
219 def information_schema PLUGINS PLUGIN_LIBRARY 6 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
220 def information_schema PLUGINS PLUGIN_LIBRARY_VERSION 7 YES varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL
221 def information_schema PLUGINS PLUGIN_AUTHOR 8 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
222 def information_schema PLUGINS PLUGIN_DESCRIPTION 9 YES varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL
223 def information_schema PLUGINS PLUGIN_LICENSE 10 YES varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
224 def information_schema PLUGINS LOAD_OPTION 11 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
225 def information_schema PROCESSLIST ID 1 NO bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL
226 def information_schema PROCESSLIST USER 2 NO varchar 10 32 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(32) select NULL
227 def information_schema PROCESSLIST HOST 3 NO varchar 87 261 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(261) select NULL
228 def information_schema PROCESSLIST DB 4 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
229 def information_schema PROCESSLIST COMMAND 5 NO varchar 5 16 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(16) select NULL
230 def information_schema PROCESSLIST TIME 6 NO int NULL NULL NULL NULL NULL NULL NULL int select NULL
231 def information_schema PROCESSLIST STATE 7 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
232 def information_schema PROCESSLIST INFO 8 YES varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL
233 def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
234 def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
235 def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
236 def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
237 def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
238 def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
239 def information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION 7 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NONE','PARTIAL','FULL') select NULL
240 def information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE 8 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') select NULL
241 def information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE 9 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') select NULL
242 def information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
243 def information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME 11 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
244 def information_schema RESOURCE_GROUPS RESOURCE_GROUP_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
245 def information_schema RESOURCE_GROUPS RESOURCE_GROUP_TYPE 2 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('SYSTEM','USER') select NULL
246 def information_schema RESOURCE_GROUPS RESOURCE_GROUP_ENABLED 3 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select NULL
247 def information_schema RESOURCE_GROUPS VCPU_IDS 4 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select NULL
248 def information_schema RESOURCE_GROUPS THREAD_PRIORITY 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int select NULL
249 def information_schema ROLE_COLUMN_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL
250 def information_schema ROLE_COLUMN_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
251 def information_schema ROLE_COLUMN_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL
252 def information_schema ROLE_COLUMN_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL
253 def information_schema ROLE_COLUMN_GRANTS TABLE_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
254 def information_schema ROLE_COLUMN_GRANTS TABLE_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
255 def information_schema ROLE_COLUMN_GRANTS TABLE_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
256 def information_schema ROLE_COLUMN_GRANTS COLUMN_NAME 8 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
257 def information_schema ROLE_COLUMN_GRANTS PRIVILEGE_TYPE 9 NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') select NULL
258 def information_schema ROLE_COLUMN_GRANTS IS_GRANTABLE 10 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
259 def information_schema ROLE_ROUTINE_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL
260 def information_schema ROLE_ROUTINE_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
261 def information_schema ROLE_ROUTINE_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL
262 def information_schema ROLE_ROUTINE_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL
263 def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
264 def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
265 def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select NULL
266 def information_schema ROLE_ROUTINE_GRANTS ROUTINE_CATALOG 8 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
267 def information_schema ROLE_ROUTINE_GRANTS ROUTINE_SCHEMA 9 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
268 def information_schema ROLE_ROUTINE_GRANTS ROUTINE_NAME 10 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select NULL
269 def information_schema ROLE_ROUTINE_GRANTS PRIVILEGE_TYPE 11 NO set 27 81 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant') select NULL
270 def information_schema ROLE_ROUTINE_GRANTS IS_GRANTABLE 12 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
271 def information_schema ROLE_TABLE_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL
272 def information_schema ROLE_TABLE_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
273 def information_schema ROLE_TABLE_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL
274 def information_schema ROLE_TABLE_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL
275 def information_schema ROLE_TABLE_GRANTS TABLE_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
276 def information_schema ROLE_TABLE_GRANTS TABLE_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
277 def information_schema ROLE_TABLE_GRANTS TABLE_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL
278 def information_schema ROLE_TABLE_GRANTS PRIVILEGE_TYPE 8 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 NULL
279 def information_schema ROLE_TABLE_GRANTS IS_GRANTABLE 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
280 def information_schema ROUTINES SPECIFIC_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
281 def information_schema ROUTINES ROUTINE_CATALOG 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
282 def information_schema ROUTINES ROUTINE_SCHEMA 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
283 def information_schema ROUTINES ROUTINE_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
284 def information_schema ROUTINES ROUTINE_TYPE 5 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL
285 def information_schema ROUTINES DATA_TYPE 6 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
286 def information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH 7 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
287 def information_schema ROUTINES CHARACTER_OCTET_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
288 def information_schema ROUTINES NUMERIC_PRECISION 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
289 def information_schema ROUTINES NUMERIC_SCALE 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
290 def information_schema ROUTINES DATETIME_PRECISION 11 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
291 def information_schema ROUTINES CHARACTER_SET_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
292 def information_schema ROUTINES COLLATION_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
293 def information_schema ROUTINES DTD_IDENTIFIER 14 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
294 def information_schema ROUTINES ROUTINE_BODY 15 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
295 def information_schema ROUTINES ROUTINE_DEFINITION 16 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
296 def information_schema ROUTINES EXTERNAL_NAME 17 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
297 def information_schema ROUTINES EXTERNAL_LANGUAGE 18 SQL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
298 def information_schema ROUTINES PARAMETER_STYLE 19 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
299 def information_schema ROUTINES IS_DETERMINISTIC 20 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
300 def information_schema ROUTINES SQL_DATA_ACCESS 21 NULL NO enum 17 51 NULL NULL NULL utf8mb3 utf8mb3_bin enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') select NULL
301 def information_schema ROUTINES SQL_PATH 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
302 def information_schema ROUTINES SECURITY_TYPE 23 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('DEFAULT','INVOKER','DEFINER') select NULL
303 def information_schema ROUTINES CREATED 24 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
304 def information_schema ROUTINES LAST_ALTERED 25 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
305 def information_schema ROUTINES SQL_MODE 26 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL
306 def information_schema ROUTINES ROUTINE_COMMENT 27 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
307 def information_schema ROUTINES DEFINER 28 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
308 def information_schema ROUTINES CHARACTER_SET_CLIENT 29 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
309 def information_schema ROUTINES COLLATION_CONNECTION 30 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
310 def information_schema ROUTINES DATABASE_COLLATION 31 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
311 def information_schema SCHEMATA CATALOG_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
312 def information_schema SCHEMATA SCHEMA_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
313 def information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
314 def information_schema SCHEMATA DEFAULT_COLLATION_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
315 def information_schema SCHEMATA SQL_PATH 5 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
316 def information_schema SCHEMATA DEFAULT_ENCRYPTION 6 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO','YES') select NULL
317 def information_schema SCHEMATA_EXTENSIONS CATALOG_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
318 def information_schema SCHEMATA_EXTENSIONS SCHEMA_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
319 def information_schema SCHEMATA_EXTENSIONS OPTIONS 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
320 def information_schema SCHEMA_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL
321 def information_schema SCHEMA_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL
322 def information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
323 def information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
324 def information_schema SCHEMA_PRIVILEGES IS_GRANTABLE 5 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
325 def information_schema STATISTICS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
326 def information_schema STATISTICS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
327 def information_schema STATISTICS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
328 def information_schema STATISTICS NON_UNIQUE 4 0 NO int NULL NULL 10 0 NULL NULL NULL int select NULL
329 def information_schema STATISTICS INDEX_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
330 def information_schema STATISTICS INDEX_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
331 def information_schema STATISTICS SEQ_IN_INDEX 7 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
332 def information_schema STATISTICS COLUMN_NAME 8 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
333 def information_schema STATISTICS COLLATION 9 NULL YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(1) select NULL
334 def information_schema STATISTICS CARDINALITY 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
335 def information_schema STATISTICS SUB_PART 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
336 def information_schema STATISTICS PACKED 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
337 def information_schema STATISTICS NULLABLE 13 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
338 def information_schema STATISTICS INDEX_TYPE 14 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL
339 def information_schema STATISTICS COMMENT 15 NO varchar 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL
340 def information_schema STATISTICS INDEX_COMMENT 16 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
341 def information_schema STATISTICS IS_VISIBLE 17 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
342 def information_schema STATISTICS EXPRESSION 18 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
343 def information_schema ST_GEOMETRY_COLUMNS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
344 def information_schema ST_GEOMETRY_COLUMNS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
345 def information_schema ST_GEOMETRY_COLUMNS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
346 def information_schema ST_GEOMETRY_COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
347 def information_schema ST_GEOMETRY_COLUMNS SRS_NAME 5 NULL YES varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
348 def information_schema ST_GEOMETRY_COLUMNS SRS_ID 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
349 def information_schema ST_GEOMETRY_COLUMNS GEOMETRY_TYPE_NAME 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
350 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_NAME 1 NULL NO varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
351 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_ID 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
352 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
353 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION_COORDSYS_ID 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
354 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DEFINITION 5 NULL NO varchar 4096 12288 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(4096) select NULL
355 def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DESCRIPTION 6 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
356 def information_schema ST_UNITS_OF_MEASURE UNIT_NAME 1 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
357 def information_schema ST_UNITS_OF_MEASURE UNIT_TYPE 2 NULL YES varchar 7 28 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(7) select NULL
358 def information_schema ST_UNITS_OF_MEASURE CONVERSION_FACTOR 3 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select NULL
359 def information_schema ST_UNITS_OF_MEASURE DESCRIPTION 4 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
360 def information_schema TABLES TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
361 def information_schema TABLES TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
362 def information_schema TABLES TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
363 def information_schema TABLES TABLE_TYPE 4 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('BASE TABLE','VIEW','SYSTEM VIEW') select NULL
364 def information_schema TABLES ENGINE 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
365 def information_schema TABLES VERSION 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select NULL
366 def information_schema TABLES ROW_FORMAT 7 NULL YES enum 10 30 NULL NULL NULL utf8mb3 utf8mb3_bin enum('Fixed','Dynamic','Compressed','Redundant','Compact','Paged') select NULL
367 def information_schema TABLES TABLE_ROWS 8 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
368 def information_schema TABLES AVG_ROW_LENGTH 9 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
369 def information_schema TABLES DATA_LENGTH 10 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
370 def information_schema TABLES MAX_DATA_LENGTH 11 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
371 def information_schema TABLES INDEX_LENGTH 12 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
372 def information_schema TABLES DATA_FREE 13 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
373 def information_schema TABLES AUTO_INCREMENT 14 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
374 def information_schema TABLES CREATE_TIME 15 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
375 def information_schema TABLES UPDATE_TIME 16 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
376 def information_schema TABLES CHECK_TIME 17 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
377 def information_schema TABLES TABLE_COLLATION 18 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
378 def information_schema TABLES CHECKSUM 19 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
379 def information_schema TABLES CREATE_OPTIONS 20 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
380 def information_schema TABLES TABLE_COMMENT 21 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select NULL
381 def information_schema TABLESPACES TABLESPACE_NAME 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
382 def information_schema TABLESPACES ENGINE 2 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
383 def information_schema TABLESPACES TABLESPACE_TYPE 3 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
384 def information_schema TABLESPACES LOGFILE_GROUP_NAME 4 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
385 def information_schema TABLESPACES EXTENT_SIZE 5 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL
386 def information_schema TABLESPACES AUTOEXTEND_SIZE 6 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL
387 def information_schema TABLESPACES MAXIMUM_SIZE 7 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL
388 def information_schema TABLESPACES NODEGROUP_ID 8 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL
389 def information_schema TABLESPACES TABLESPACE_COMMENT 9 YES varchar 682 2048 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) select NULL
390 def information_schema TABLESPACES_EXTENSIONS TABLESPACE_NAME 1 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
391 def information_schema TABLESPACES_EXTENSIONS ENGINE_ATTRIBUTE 2 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
392 def information_schema TABLES_EXTENSIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
393 def information_schema TABLES_EXTENSIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
394 def information_schema TABLES_EXTENSIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
395 def information_schema TABLES_EXTENSIONS ENGINE_ATTRIBUTE 4 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
396 def information_schema TABLES_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
397 def information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
398 def information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
399 def information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
400 def information_schema TABLE_CONSTRAINTS TABLE_SCHEMA 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
401 def information_schema TABLE_CONSTRAINTS TABLE_NAME 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
402 def information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE 6 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL
403 def information_schema TABLE_CONSTRAINTS ENFORCED 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(3) select NULL
404 def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
405 def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
406 def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL
407 def information_schema TABLE_CONSTRAINTS_EXTENSIONS TABLE_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
408 def information_schema TABLE_CONSTRAINTS_EXTENSIONS ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
409 def information_schema TABLE_CONSTRAINTS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 6 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
410 def information_schema TABLE_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL
411 def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL
412 def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
413 def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
414 def information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE 5 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
415 def information_schema TABLE_PRIVILEGES IS_GRANTABLE 6 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
416 def information_schema TRIGGERS TRIGGER_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
417 def information_schema TRIGGERS TRIGGER_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
418 def information_schema TRIGGERS TRIGGER_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
419 def information_schema TRIGGERS EVENT_MANIPULATION 4 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('INSERT','UPDATE','DELETE') select NULL
420 def information_schema TRIGGERS EVENT_OBJECT_CATALOG 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
421 def information_schema TRIGGERS EVENT_OBJECT_SCHEMA 6 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
422 def information_schema TRIGGERS EVENT_OBJECT_TABLE 7 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
423 def information_schema TRIGGERS ACTION_ORDER 8 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
424 def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
425 def information_schema TRIGGERS ACTION_STATEMENT 10 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
426 def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
427 def information_schema TRIGGERS ACTION_TIMING 12 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('BEFORE','AFTER') select NULL
428 def information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE 13 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
429 def information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE 14 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
430 def information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW 15 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
431 def information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW 16 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
432 def information_schema TRIGGERS CREATED 17 NULL NO timestamp NULL NULL NULL NULL 2 NULL NULL timestamp(2) select NULL
433 def information_schema TRIGGERS SQL_MODE 18 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL
434 def information_schema TRIGGERS DEFINER 19 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
435 def information_schema TRIGGERS CHARACTER_SET_CLIENT 20 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
436 def information_schema TRIGGERS COLLATION_CONNECTION 21 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
437 def information_schema TRIGGERS DATABASE_COLLATION 22 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
438 def information_schema USER_ATTRIBUTES USER 1 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL
439 def information_schema USER_ATTRIBUTES HOST 2 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL
440 def information_schema USER_ATTRIBUTES ATTRIBUTE 3 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext select NULL
441 def information_schema USER_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL
442 def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL
443 def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
444 def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
445 def information_schema VIEWS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
446 def information_schema VIEWS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
447 def information_schema VIEWS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
448 def information_schema VIEWS VIEW_DEFINITION 4 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
449 def information_schema VIEWS CHECK_OPTION 5 NULL YES enum 8 24 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NONE','LOCAL','CASCADED') select NULL
450 def information_schema VIEWS IS_UPDATABLE 6 NULL YES enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO','YES') select NULL
451 def information_schema VIEWS DEFINER 7 NULL YES varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
452 def information_schema VIEWS SECURITY_TYPE 8 NULL YES varchar 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(7) select NULL
453 def information_schema VIEWS CHARACTER_SET_CLIENT 9 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
454 def information_schema VIEWS COLLATION_CONNECTION 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
455 def information_schema VIEW_ROUTINE_USAGE TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
456 def information_schema VIEW_ROUTINE_USAGE TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
457 def information_schema VIEW_ROUTINE_USAGE TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
458 def information_schema VIEW_ROUTINE_USAGE SPECIFIC_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
459 def information_schema VIEW_ROUTINE_USAGE SPECIFIC_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
460 def information_schema VIEW_ROUTINE_USAGE SPECIFIC_NAME 6 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
461 def information_schema VIEW_TABLE_USAGE VIEW_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
462 def information_schema VIEW_TABLE_USAGE VIEW_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
463 def information_schema VIEW_TABLE_USAGE VIEW_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
464 def information_schema VIEW_TABLE_USAGE TABLE_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
465 def information_schema VIEW_TABLE_USAGE TABLE_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
466 def information_schema VIEW_TABLE_USAGE TABLE_NAME 6 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
467 ##########################################################################
468 # Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
469 ##########################################################################
470 SELECT DISTINCT
471 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
472 DATA_TYPE,
473 CHARACTER_SET_NAME,
474 COLLATION_NAME
475 FROM information_schema.columns
476 WHERE table_schema = 'information_schema'
477 AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%'
478 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
479 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
480 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
481 1.0000 blob NULL NULL
482 1.0000 char ascii ascii_general_ci
483 1.0000 longtext utf8mb3 utf8mb3_bin
484 1.0000 mediumtext utf8mb3 utf8mb3_bin
485 1.0000 text utf8mb3 utf8mb3_bin
486 1.0000 text utf8mb3 utf8mb3_general_ci
487 1.0000 longtext utf8mb4 utf8mb4_bin
488 SELECT DISTINCT
489 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
490 DATA_TYPE,
491 CHARACTER_SET_NAME,
492 COLLATION_NAME
493 FROM information_schema.columns
494 WHERE table_schema = 'information_schema'
495 AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%'
496 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1
497 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
498 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
499 3.0000 char utf8mb3 utf8mb3_bin
500 3.0000 enum utf8mb3 utf8mb3_bin
501 3.0000 set utf8mb3 utf8mb3_bin
502 3.0000 varchar utf8mb3 utf8mb3_bin
503 3.0000 char utf8mb3 utf8mb3_general_ci
504 3.0000 set utf8mb3 utf8mb3_general_ci
505 3.0000 varchar utf8mb3 utf8mb3_general_ci
506 3.0029 varchar utf8mb3 utf8mb3_general_ci
507 3.0103 varchar utf8mb3 utf8mb3_general_ci
508 3.0118 varchar utf8mb3 utf8mb3_general_ci
509 3.0476 varchar utf8mb3 utf8mb3_general_ci
510 3.0769 varchar utf8mb3 utf8mb3_general_ci
511 3.2000 varchar utf8mb3 utf8mb3_general_ci
512 3.3333 varchar utf8mb3 utf8mb3_general_ci
513 4.0000 varchar utf8mb3 utf8mb3_general_ci
514 3.0000 varchar utf8mb3 utf8mb3_tolower_ci
515 4.0000 varchar utf8mb4 utf8mb4_0900_ai_ci
516 SELECT DISTINCT
517 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
518 DATA_TYPE,
519 CHARACTER_SET_NAME,
520 COLLATION_NAME
521 FROM information_schema.columns
522 WHERE table_schema = 'information_schema'
523 AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%'
524 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL
525 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
526 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
527 NULL bigint NULL NULL
528 NULL binary NULL NULL
529 NULL datetime NULL NULL
530 NULL double NULL NULL
531 NULL int NULL NULL
532 NULL json NULL NULL
533 NULL timestamp NULL NULL
534 NULL tinyint NULL NULL
535 NULL char utf8mb3 utf8mb3_general_ci
536 --> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values
537 --> are 0, which is intended behavior, and the result of 0 / 0 IS NULL
538 SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
539 TABLE_SCHEMA,
540 TABLE_NAME,
541 COLUMN_NAME,
542 DATA_TYPE,
543 CHARACTER_MAXIMUM_LENGTH,
544 CHARACTER_OCTET_LENGTH,
545 CHARACTER_SET_NAME,
546 COLLATION_NAME,
547 COLUMN_TYPE
548 FROM information_schema.columns
549 WHERE table_schema = 'information_schema'
550 AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%'
551 ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION;
552 COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
553 3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS USER varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97)
554 3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
555 4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE varchar 97 388 utf8mb4 utf8mb4_0900_ai_ci varchar(97)
556 4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256)
557 4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
558 4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256)
559 3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
560 3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
561 3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
562 3.0000 information_schema APPLICABLE_ROLES USER varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97)
563 3.0000 information_schema APPLICABLE_ROLES HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
564 4.0000 information_schema APPLICABLE_ROLES GRANTEE varchar 97 388 utf8mb4 utf8mb4_0900_ai_ci varchar(97)
565 4.0000 information_schema APPLICABLE_ROLES GRANTEE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256)
566 4.0000 information_schema APPLICABLE_ROLES ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
567 4.0000 information_schema APPLICABLE_ROLES ROLE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256)
568 3.0000 information_schema APPLICABLE_ROLES IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
569 3.0000 information_schema APPLICABLE_ROLES IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
570 3.0000 information_schema APPLICABLE_ROLES IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
571 3.0000 information_schema CHARACTER_SETS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
572 3.0000 information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
573 3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 2048 6144 utf8mb3 utf8mb3_general_ci varchar(2048)
574 NULL information_schema CHARACTER_SETS MAXLEN int NULL NULL NULL NULL int unsigned
575 3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
576 3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
577 3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
578 1.0000 information_schema CHECK_CONSTRAINTS CHECK_CLAUSE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
579 3.0000 information_schema COLLATIONS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
580 3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
581 NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint unsigned
582 3.0000 information_schema COLLATIONS IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
583 3.0000 information_schema COLLATIONS IS_COMPILED varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
584 NULL information_schema COLLATIONS SORTLEN int NULL NULL NULL NULL int unsigned
585 3.0000 information_schema COLLATIONS PAD_ATTRIBUTE enum 9 27 utf8mb3 utf8mb3_bin enum('PAD SPACE','NO PAD')
586 3.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
587 3.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
588 3.0000 information_schema COLUMNS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
589 3.0000 information_schema COLUMNS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
590 3.0000 information_schema COLUMNS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
591 3.0000 information_schema COLUMNS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
592 NULL information_schema COLUMNS ORDINAL_POSITION int NULL NULL NULL NULL int unsigned
593 1.0000 information_schema COLUMNS COLUMN_DEFAULT text 65535 65535 utf8mb3 utf8mb3_bin text
594 3.0000 information_schema COLUMNS IS_NULLABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
595 1.0000 information_schema COLUMNS DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
596 NULL information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint
597 NULL information_schema COLUMNS CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint
598 NULL information_schema COLUMNS NUMERIC_PRECISION bigint NULL NULL NULL NULL bigint unsigned
599 NULL information_schema COLUMNS NUMERIC_SCALE bigint NULL NULL NULL NULL bigint unsigned
600 NULL information_schema COLUMNS DATETIME_PRECISION int NULL NULL NULL NULL int unsigned
601 3.0000 information_schema COLUMNS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
602 3.0000 information_schema COLUMNS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
603 1.0000 information_schema COLUMNS COLUMN_TYPE mediumtext 16777215 16777215 utf8mb3 utf8mb3_bin mediumtext
604 3.0000 information_schema COLUMNS COLUMN_KEY enum 3 9 utf8mb3 utf8mb3_bin enum('','PRI','UNI','MUL')
605 3.0000 information_schema COLUMNS EXTRA varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
606 3.0000 information_schema COLUMNS PRIVILEGES varchar 154 462 utf8mb3 utf8mb3_general_ci varchar(154)
607 1.0000 information_schema COLUMNS COLUMN_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text
608 1.0000 information_schema COLUMNS GENERATION_EXPRESSION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
609 NULL information_schema COLUMNS SRS_ID int NULL NULL NULL NULL int unsigned
610 3.0000 information_schema COLUMNS_EXTENSIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
611 3.0000 information_schema COLUMNS_EXTENSIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
612 3.0000 information_schema COLUMNS_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
613 3.0000 information_schema COLUMNS_EXTENSIONS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
614 NULL information_schema COLUMNS_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
615 NULL information_schema COLUMNS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
616 3.0103 information_schema COLUMN_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292)
617 3.0118 information_schema COLUMN_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512)
618 3.0476 information_schema COLUMN_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
619 3.0476 information_schema COLUMN_PRIVILEGES TABLE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
620 3.0476 information_schema COLUMN_PRIVILEGES COLUMN_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
621 3.0476 information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
622 3.0000 information_schema COLUMN_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
623 3.0000 information_schema COLUMN_STATISTICS SCHEMA_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
624 3.0000 information_schema COLUMN_STATISTICS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
625 3.0000 information_schema COLUMN_STATISTICS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
626 NULL information_schema COLUMN_STATISTICS HISTOGRAM json NULL NULL NULL NULL json
627 4.0000 information_schema ENABLED_ROLES ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
628 4.0000 information_schema ENABLED_ROLES ROLE_HOST varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
629 3.0000 information_schema ENABLED_ROLES IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
630 3.0000 information_schema ENABLED_ROLES IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
631 3.0476 information_schema ENGINES ENGINE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
632 4.0000 information_schema ENGINES SUPPORT varchar 2 8 utf8mb3 utf8mb3_general_ci varchar(8)
633 3.0769 information_schema ENGINES COMMENT varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80)
634 3.0000 information_schema ENGINES TRANSACTIONS varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
635 3.0000 information_schema ENGINES XA varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
636 3.0000 information_schema ENGINES SAVEPOINTS varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
637 3.0000 information_schema EVENTS EVENT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
638 3.0000 information_schema EVENTS EVENT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
639 3.0000 information_schema EVENTS EVENT_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
640 3.0000 information_schema EVENTS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288)
641 3.0000 information_schema EVENTS TIME_ZONE varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
642 3.0000 information_schema EVENTS EVENT_BODY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
643 1.0000 information_schema EVENTS EVENT_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
644 3.0000 information_schema EVENTS EVENT_TYPE varchar 9 27 utf8mb3 utf8mb3_general_ci varchar(9)
645 NULL information_schema EVENTS EXECUTE_AT datetime NULL NULL NULL NULL datetime
646 3.0000 information_schema EVENTS INTERVAL_VALUE varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
647 3.0000 information_schema EVENTS INTERVAL_FIELD enum 18 54 utf8mb3 utf8mb3_bin 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')
648 3.0000 information_schema EVENTS SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL')
649 NULL information_schema EVENTS STARTS datetime NULL NULL NULL NULL datetime
650 NULL information_schema EVENTS ENDS datetime NULL NULL NULL NULL datetime
651 3.0000 information_schema EVENTS STATUS enum 18 54 utf8mb3 utf8mb3_bin enum('ENABLED','DISABLED','SLAVESIDE_DISABLED')
652 3.0000 information_schema EVENTS ON_COMPLETION varchar 12 36 utf8mb3 utf8mb3_general_ci varchar(12)
653 NULL information_schema EVENTS CREATED timestamp NULL NULL NULL NULL timestamp
654 NULL information_schema EVENTS LAST_ALTERED timestamp NULL NULL NULL NULL timestamp
655 NULL information_schema EVENTS LAST_EXECUTED datetime NULL NULL NULL NULL datetime
656 3.0000 information_schema EVENTS EVENT_COMMENT varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048)
657 NULL information_schema EVENTS ORIGINATOR int NULL NULL NULL NULL int unsigned
658 3.0000 information_schema EVENTS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
659 3.0000 information_schema EVENTS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
660 3.0000 information_schema EVENTS DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
661 NULL information_schema FILES FILE_ID bigint NULL NULL NULL NULL bigint
662 1.0000 information_schema FILES FILE_NAME text 65535 65535 utf8mb3 utf8mb3_bin text
663 3.0000 information_schema FILES FILE_TYPE varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
664 3.0000 information_schema FILES TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268)
665 NULL information_schema FILES TABLE_CATALOG char 0 0 utf8mb3 utf8mb3_general_ci char(0)
666 NULL information_schema FILES TABLE_SCHEMA binary 0 0 NULL NULL binary(0)
667 NULL information_schema FILES TABLE_NAME binary 0 0 NULL NULL binary(0)
668 3.0000 information_schema FILES LOGFILE_GROUP_NAME varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
669 NULL information_schema FILES LOGFILE_GROUP_NUMBER bigint NULL NULL NULL NULL bigint
670 3.0000 information_schema FILES ENGINE varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
671 NULL information_schema FILES FULLTEXT_KEYS binary 0 0 NULL NULL binary(0)
672 NULL information_schema FILES DELETED_ROWS binary 0 0 NULL NULL binary(0)
673 NULL information_schema FILES UPDATE_COUNT binary 0 0 NULL NULL binary(0)
674 NULL information_schema FILES FREE_EXTENTS bigint NULL NULL NULL NULL bigint
675 NULL information_schema FILES TOTAL_EXTENTS bigint NULL NULL NULL NULL bigint
676 NULL information_schema FILES EXTENT_SIZE bigint NULL NULL NULL NULL bigint
677 NULL information_schema FILES INITIAL_SIZE bigint NULL NULL NULL NULL bigint
678 NULL information_schema FILES MAXIMUM_SIZE bigint NULL NULL NULL NULL bigint
679 NULL information_schema FILES AUTOEXTEND_SIZE bigint NULL NULL NULL NULL bigint
680 NULL information_schema FILES CREATION_TIME binary 0 0 NULL NULL binary(0)
681 NULL information_schema FILES LAST_UPDATE_TIME binary 0 0 NULL NULL binary(0)
682 NULL information_schema FILES LAST_ACCESS_TIME binary 0 0 NULL NULL binary(0)
683 NULL information_schema FILES RECOVER_TIME binary 0 0 NULL NULL binary(0)
684 NULL information_schema FILES TRANSACTION_COUNTER binary 0 0 NULL NULL binary(0)
685 NULL information_schema FILES VERSION bigint NULL NULL NULL NULL bigint
686 3.0000 information_schema FILES ROW_FORMAT varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
687 NULL information_schema FILES TABLE_ROWS binary 0 0 NULL NULL binary(0)
688 NULL information_schema FILES AVG_ROW_LENGTH binary 0 0 NULL NULL binary(0)
689 NULL information_schema FILES DATA_LENGTH binary 0 0 NULL NULL binary(0)
690 NULL information_schema FILES MAX_DATA_LENGTH binary 0 0 NULL NULL binary(0)
691 NULL information_schema FILES INDEX_LENGTH binary 0 0 NULL NULL binary(0)
692 NULL information_schema FILES DATA_FREE bigint NULL NULL NULL NULL bigint
693 NULL information_schema FILES CREATE_TIME binary 0 0 NULL NULL binary(0)
694 NULL information_schema FILES UPDATE_TIME binary 0 0 NULL NULL binary(0)
695 NULL information_schema FILES CHECK_TIME binary 0 0 NULL NULL binary(0)
696 NULL information_schema FILES CHECKSUM binary 0 0 NULL NULL binary(0)
697 3.0000 information_schema FILES STATUS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
698 3.0000 information_schema FILES EXTRA varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
699 4.0000 information_schema KEYWORDS WORD varchar 128 512 utf8mb4 utf8mb4_0900_ai_ci varchar(128)
700 NULL information_schema KEYWORDS RESERVED int NULL NULL NULL NULL int
701 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
702 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
703 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
704 3.0000 information_schema KEY_COLUMN_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
705 3.0000 information_schema KEY_COLUMN_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
706 3.0000 information_schema KEY_COLUMN_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
707 3.0000 information_schema KEY_COLUMN_USAGE COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
708 NULL information_schema KEY_COLUMN_USAGE ORDINAL_POSITION int NULL NULL NULL NULL int unsigned
709 NULL information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT int NULL NULL NULL NULL int unsigned
710 3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
711 3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
712 3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
713 3.0000 information_schema OPTIMIZER_TRACE QUERY varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535)
714 3.0000 information_schema OPTIMIZER_TRACE TRACE varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535)
715 NULL information_schema OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE int NULL NULL NULL NULL int
716 NULL information_schema OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES tinyint NULL NULL NULL NULL tinyint(1)
717 3.0000 information_schema PARAMETERS SPECIFIC_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
718 3.0000 information_schema PARAMETERS SPECIFIC_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
719 3.0000 information_schema PARAMETERS SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
720 NULL information_schema PARAMETERS ORDINAL_POSITION bigint NULL NULL NULL NULL bigint unsigned
721 3.0000 information_schema PARAMETERS PARAMETER_MODE varchar 5 15 utf8mb3 utf8mb3_bin varchar(5)
722 3.0000 information_schema PARAMETERS PARAMETER_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
723 1.0000 information_schema PARAMETERS DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
724 NULL information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint
725 NULL information_schema PARAMETERS CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint
726 NULL information_schema PARAMETERS NUMERIC_PRECISION int NULL NULL NULL NULL int unsigned
727 NULL information_schema PARAMETERS NUMERIC_SCALE bigint NULL NULL NULL NULL bigint
728 NULL information_schema PARAMETERS DATETIME_PRECISION int NULL NULL NULL NULL int unsigned
729 3.0000 information_schema PARAMETERS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
730 3.0000 information_schema PARAMETERS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
731 1.0000 information_schema PARAMETERS DTD_IDENTIFIER mediumtext 16777215 16777215 utf8mb3 utf8mb3_bin mediumtext
732 3.0000 information_schema PARAMETERS ROUTINE_TYPE enum 9 27 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE')
733 3.0000 information_schema PARTITIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
734 3.0000 information_schema PARTITIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
735 3.0000 information_schema PARTITIONS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
736 3.0000 information_schema PARTITIONS PARTITION_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
737 3.0000 information_schema PARTITIONS SUBPARTITION_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
738 NULL information_schema PARTITIONS PARTITION_ORDINAL_POSITION int NULL NULL NULL NULL int unsigned
739 NULL information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION int NULL NULL NULL NULL int unsigned
740 3.0000 information_schema PARTITIONS PARTITION_METHOD varchar 13 39 utf8mb3 utf8mb3_general_ci varchar(13)
741 3.0000 information_schema PARTITIONS SUBPARTITION_METHOD varchar 13 39 utf8mb3 utf8mb3_general_ci varchar(13)
742 3.0000 information_schema PARTITIONS PARTITION_EXPRESSION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048)
743 3.0000 information_schema PARTITIONS SUBPARTITION_EXPRESSION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048)
744 1.0000 information_schema PARTITIONS PARTITION_DESCRIPTION text 65535 65535 utf8mb3 utf8mb3_bin text
745 NULL information_schema PARTITIONS TABLE_ROWS bigint NULL NULL NULL NULL bigint unsigned
746 NULL information_schema PARTITIONS AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint unsigned
747 NULL information_schema PARTITIONS DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned
748 NULL information_schema PARTITIONS MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned
749 NULL information_schema PARTITIONS INDEX_LENGTH bigint NULL NULL NULL NULL bigint unsigned
750 NULL information_schema PARTITIONS DATA_FREE bigint NULL NULL NULL NULL bigint unsigned
751 NULL information_schema PARTITIONS CREATE_TIME timestamp NULL NULL NULL NULL timestamp
752 NULL information_schema PARTITIONS UPDATE_TIME datetime NULL NULL NULL NULL datetime
753 NULL information_schema PARTITIONS CHECK_TIME datetime NULL NULL NULL NULL datetime
754 NULL information_schema PARTITIONS CHECKSUM bigint NULL NULL NULL NULL bigint
755 1.0000 information_schema PARTITIONS PARTITION_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text
756 3.0000 information_schema PARTITIONS NODEGROUP varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
757 3.0000 information_schema PARTITIONS TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268)
758 3.0476 information_schema PLUGINS PLUGIN_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
759 3.3333 information_schema PLUGINS PLUGIN_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20)
760 3.3333 information_schema PLUGINS PLUGIN_STATUS varchar 3 10 utf8mb3 utf8mb3_general_ci varchar(10)
761 3.0769 information_schema PLUGINS PLUGIN_TYPE varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80)
762 3.3333 information_schema PLUGINS PLUGIN_TYPE_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20)
763 3.0476 information_schema PLUGINS PLUGIN_LIBRARY varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
764 3.3333 information_schema PLUGINS PLUGIN_LIBRARY_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20)
765 3.0476 information_schema PLUGINS PLUGIN_AUTHOR varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
766 3.0000 information_schema PLUGINS PLUGIN_DESCRIPTION varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535)
767 3.0769 information_schema PLUGINS PLUGIN_LICENSE varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80)
768 3.0476 information_schema PLUGINS LOAD_OPTION varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
769 NULL information_schema PROCESSLIST ID bigint NULL NULL NULL NULL bigint unsigned
770 3.2000 information_schema PROCESSLIST USER varchar 10 32 utf8mb3 utf8mb3_general_ci varchar(32)
771 3.0000 information_schema PROCESSLIST HOST varchar 87 261 utf8mb3 utf8mb3_general_ci varchar(261)
772 3.0476 information_schema PROCESSLIST DB varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
773 3.2000 information_schema PROCESSLIST COMMAND varchar 5 16 utf8mb3 utf8mb3_general_ci varchar(16)
774 NULL information_schema PROCESSLIST TIME int NULL NULL NULL NULL int
775 3.0476 information_schema PROCESSLIST STATE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
776 3.0000 information_schema PROCESSLIST INFO varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535)
777 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
778 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
779 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
780 3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
781 3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
782 3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
783 3.0000 information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION enum 7 21 utf8mb3 utf8mb3_bin enum('NONE','PARTIAL','FULL')
784 3.0000 information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE enum 11 33 utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT')
785 3.0000 information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE enum 11 33 utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT')
786 3.0000 information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
787 3.0000 information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
788 3.0000 information_schema RESOURCE_GROUPS RESOURCE_GROUP_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
789 3.0000 information_schema RESOURCE_GROUPS RESOURCE_GROUP_TYPE enum 6 18 utf8mb3 utf8mb3_bin enum('SYSTEM','USER')
790 NULL information_schema RESOURCE_GROUPS RESOURCE_GROUP_ENABLED tinyint NULL NULL NULL NULL tinyint(1)
791 1.0000 information_schema RESOURCE_GROUPS VCPU_IDS blob 65535 65535 NULL NULL blob
792 NULL information_schema RESOURCE_GROUPS THREAD_PRIORITY int NULL NULL NULL NULL int
793 3.0000 information_schema ROLE_COLUMN_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97)
794 3.0000 information_schema ROLE_COLUMN_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
795 3.0000 information_schema ROLE_COLUMN_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32)
796 1.0000 information_schema ROLE_COLUMN_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255)
797 3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
798 3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64)
799 3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_NAME char 64 192 utf8mb3 utf8mb3_bin char(64)
800 3.0000 information_schema ROLE_COLUMN_GRANTS COLUMN_NAME char 64 192 utf8mb3 utf8mb3_bin char(64)
801 3.0000 information_schema ROLE_COLUMN_GRANTS PRIVILEGE_TYPE set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References')
802 3.0000 information_schema ROLE_COLUMN_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
803 3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97)
804 3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
805 3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32)
806 1.0000 information_schema ROLE_ROUTINE_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255)
807 3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
808 3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64)
809 3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_NAME char 64 192 utf8mb3 utf8mb3_general_ci char(64)
810 3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
811 3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64)
812 3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_NAME char 64 192 utf8mb3 utf8mb3_general_ci char(64)
813 3.0000 information_schema ROLE_ROUTINE_GRANTS PRIVILEGE_TYPE set 27 81 utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant')
814 3.0000 information_schema ROLE_ROUTINE_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
815 3.0000 information_schema ROLE_TABLE_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97)
816 3.0000 information_schema ROLE_TABLE_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
817 3.0000 information_schema ROLE_TABLE_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32)
818 1.0000 information_schema ROLE_TABLE_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255)
819 3.0000 information_schema ROLE_TABLE_GRANTS TABLE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
820 3.0000 information_schema ROLE_TABLE_GRANTS TABLE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64)
821 3.0000 information_schema ROLE_TABLE_GRANTS TABLE_NAME char 64 192 utf8mb3 utf8mb3_bin char(64)
822 3.0000 information_schema ROLE_TABLE_GRANTS PRIVILEGE_TYPE set 98 294 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger')
823 3.0000 information_schema ROLE_TABLE_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
824 3.0000 information_schema ROUTINES SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
825 3.0000 information_schema ROUTINES ROUTINE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
826 3.0000 information_schema ROUTINES ROUTINE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
827 3.0000 information_schema ROUTINES ROUTINE_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
828 3.0000 information_schema ROUTINES ROUTINE_TYPE enum 9 27 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE')
829 1.0000 information_schema ROUTINES DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
830 NULL information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint
831 NULL information_schema ROUTINES CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint
832 NULL information_schema ROUTINES NUMERIC_PRECISION int NULL NULL NULL NULL int unsigned
833 NULL information_schema ROUTINES NUMERIC_SCALE int NULL NULL NULL NULL int unsigned
834 NULL information_schema ROUTINES DATETIME_PRECISION int NULL NULL NULL NULL int unsigned
835 3.0000 information_schema ROUTINES CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
836 3.0000 information_schema ROUTINES COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
837 1.0000 information_schema ROUTINES DTD_IDENTIFIER longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
838 3.0000 information_schema ROUTINES ROUTINE_BODY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
839 1.0000 information_schema ROUTINES ROUTINE_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
840 NULL information_schema ROUTINES EXTERNAL_NAME binary 0 0 NULL NULL binary(0)
841 3.0000 information_schema ROUTINES EXTERNAL_LANGUAGE varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
842 3.0000 information_schema ROUTINES PARAMETER_STYLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
843 3.0000 information_schema ROUTINES IS_DETERMINISTIC varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
844 3.0000 information_schema ROUTINES SQL_DATA_ACCESS enum 17 51 utf8mb3 utf8mb3_bin enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA')
845 NULL information_schema ROUTINES SQL_PATH binary 0 0 NULL NULL binary(0)
846 3.0000 information_schema ROUTINES SECURITY_TYPE enum 7 21 utf8mb3 utf8mb3_bin enum('DEFAULT','INVOKER','DEFINER')
847 NULL information_schema ROUTINES CREATED timestamp NULL NULL NULL NULL timestamp
848 NULL information_schema ROUTINES LAST_ALTERED timestamp NULL NULL NULL NULL timestamp
849 3.0000 information_schema ROUTINES SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL')
850 1.0000 information_schema ROUTINES ROUTINE_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text
851 3.0000 information_schema ROUTINES DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288)
852 3.0000 information_schema ROUTINES CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
853 3.0000 information_schema ROUTINES COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
854 3.0000 information_schema ROUTINES DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
855 3.0000 information_schema SCHEMATA CATALOG_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
856 3.0000 information_schema SCHEMATA SCHEMA_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
857 3.0000 information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
858 3.0000 information_schema SCHEMATA DEFAULT_COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
859 NULL information_schema SCHEMATA SQL_PATH binary 0 0 NULL NULL binary(0)
860 3.0000 information_schema SCHEMATA DEFAULT_ENCRYPTION enum 3 9 utf8mb3 utf8mb3_bin enum('NO','YES')
861 3.0000 information_schema SCHEMATA_EXTENSIONS CATALOG_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
862 3.0000 information_schema SCHEMATA_EXTENSIONS SCHEMA_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
863 3.0000 information_schema SCHEMATA_EXTENSIONS OPTIONS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
864 3.0103 information_schema SCHEMA_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292)
865 3.0118 information_schema SCHEMA_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512)
866 3.0476 information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
867 3.0476 information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
868 3.0000 information_schema SCHEMA_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
869 3.0000 information_schema STATISTICS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
870 3.0000 information_schema STATISTICS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
871 3.0000 information_schema STATISTICS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
872 NULL information_schema STATISTICS NON_UNIQUE int NULL NULL NULL NULL int
873 3.0000 information_schema STATISTICS INDEX_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
874 3.0000 information_schema STATISTICS INDEX_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
875 NULL information_schema STATISTICS SEQ_IN_INDEX int NULL NULL NULL NULL int unsigned
876 3.0000 information_schema STATISTICS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
877 3.0000 information_schema STATISTICS COLLATION varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(1)
878 NULL information_schema STATISTICS CARDINALITY bigint NULL NULL NULL NULL bigint
879 NULL information_schema STATISTICS SUB_PART bigint NULL NULL NULL NULL bigint
880 NULL information_schema STATISTICS PACKED binary 0 0 NULL NULL binary(0)
881 3.0000 information_schema STATISTICS NULLABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
882 3.0000 information_schema STATISTICS INDEX_TYPE varchar 11 33 utf8mb3 utf8mb3_bin varchar(11)
883 3.0000 information_schema STATISTICS COMMENT varchar 8 24 utf8mb3 utf8mb3_general_ci varchar(8)
884 3.0000 information_schema STATISTICS INDEX_COMMENT varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048)
885 3.0000 information_schema STATISTICS IS_VISIBLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
886 1.0000 information_schema STATISTICS EXPRESSION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
887 3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
888 3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
889 3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
890 3.0000 information_schema ST_GEOMETRY_COLUMNS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
891 3.0000 information_schema ST_GEOMETRY_COLUMNS SRS_NAME varchar 80 240 utf8mb3 utf8mb3_general_ci varchar(80)
892 NULL information_schema ST_GEOMETRY_COLUMNS SRS_ID int NULL NULL NULL NULL int unsigned
893 1.0000 information_schema ST_GEOMETRY_COLUMNS GEOMETRY_TYPE_NAME longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
894 3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_NAME varchar 80 240 utf8mb3 utf8mb3_general_ci varchar(80)
895 NULL information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_ID int NULL NULL NULL NULL int unsigned
896 3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
897 NULL information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION_COORDSYS_ID int NULL NULL NULL NULL int unsigned
898 3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS DEFINITION varchar 4096 12288 utf8mb3 utf8mb3_bin varchar(4096)
899 3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS DESCRIPTION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048)
900 4.0000 information_schema ST_UNITS_OF_MEASURE UNIT_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
901 4.0000 information_schema ST_UNITS_OF_MEASURE UNIT_TYPE varchar 7 28 utf8mb4 utf8mb4_0900_ai_ci varchar(7)
902 NULL information_schema ST_UNITS_OF_MEASURE CONVERSION_FACTOR double NULL NULL NULL NULL double
903 4.0000 information_schema ST_UNITS_OF_MEASURE DESCRIPTION varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255)
904 3.0000 information_schema TABLES TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
905 3.0000 information_schema TABLES TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
906 3.0000 information_schema TABLES TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
907 3.0000 information_schema TABLES TABLE_TYPE enum 11 33 utf8mb3 utf8mb3_bin enum('BASE TABLE','VIEW','SYSTEM VIEW')
908 3.0000 information_schema TABLES ENGINE varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
909 NULL information_schema TABLES VERSION int NULL NULL NULL NULL int
910 3.0000 information_schema TABLES ROW_FORMAT enum 10 30 utf8mb3 utf8mb3_bin enum('Fixed','Dynamic','Compressed','Redundant','Compact','Paged')
911 NULL information_schema TABLES TABLE_ROWS bigint NULL NULL NULL NULL bigint unsigned
912 NULL information_schema TABLES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint unsigned
913 NULL information_schema TABLES DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned
914 NULL information_schema TABLES MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned
915 NULL information_schema TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint unsigned
916 NULL information_schema TABLES DATA_FREE bigint NULL NULL NULL NULL bigint unsigned
917 NULL information_schema TABLES AUTO_INCREMENT bigint NULL NULL NULL NULL bigint unsigned
918 NULL information_schema TABLES CREATE_TIME timestamp NULL NULL NULL NULL timestamp
919 NULL information_schema TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
920 NULL information_schema TABLES CHECK_TIME datetime NULL NULL NULL NULL datetime
921 3.0000 information_schema TABLES TABLE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
922 NULL information_schema TABLES CHECKSUM bigint NULL NULL NULL NULL bigint
923 3.0000 information_schema TABLES CREATE_OPTIONS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256)
924 1.0000 information_schema TABLES TABLE_COMMENT text 65535 65535 utf8mb3 utf8mb3_general_ci text
925 3.0476 information_schema TABLESPACES TABLESPACE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
926 3.0476 information_schema TABLESPACES ENGINE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
927 3.0476 information_schema TABLESPACES TABLESPACE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
928 3.0476 information_schema TABLESPACES LOGFILE_GROUP_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
929 NULL information_schema TABLESPACES EXTENT_SIZE bigint NULL NULL NULL NULL bigint unsigned
930 NULL information_schema TABLESPACES AUTOEXTEND_SIZE bigint NULL NULL NULL NULL bigint unsigned
931 NULL information_schema TABLESPACES MAXIMUM_SIZE bigint NULL NULL NULL NULL bigint unsigned
932 NULL information_schema TABLESPACES NODEGROUP_ID bigint NULL NULL NULL NULL bigint unsigned
933 3.0029 information_schema TABLESPACES TABLESPACE_COMMENT varchar 682 2048 utf8mb3 utf8mb3_general_ci varchar(2048)
934 3.0000 information_schema TABLESPACES_EXTENSIONS TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268)
935 NULL information_schema TABLESPACES_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
936 3.0000 information_schema TABLES_EXTENSIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
937 3.0000 information_schema TABLES_EXTENSIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
938 3.0000 information_schema TABLES_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
939 NULL information_schema TABLES_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
940 NULL information_schema TABLES_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
941 3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
942 3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
943 3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
944 3.0000 information_schema TABLE_CONSTRAINTS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
945 3.0000 information_schema TABLE_CONSTRAINTS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
946 3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE varchar 11 33 utf8mb3 utf8mb3_bin varchar(11)
947 3.0000 information_schema TABLE_CONSTRAINTS ENFORCED varchar 3 9 utf8mb3 utf8mb3_bin varchar(3)
948 3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
949 3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
950 3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64)
951 3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
952 NULL information_schema TABLE_CONSTRAINTS_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
953 NULL information_schema TABLE_CONSTRAINTS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json
954 3.0103 information_schema TABLE_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292)
955 3.0118 information_schema TABLE_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512)
956 3.0476 information_schema TABLE_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
957 3.0476 information_schema TABLE_PRIVILEGES TABLE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
958 3.0476 information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
959 3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
960 3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
961 3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
962 3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
963 3.0000 information_schema TRIGGERS EVENT_MANIPULATION enum 6 18 utf8mb3 utf8mb3_bin enum('INSERT','UPDATE','DELETE')
964 3.0000 information_schema TRIGGERS EVENT_OBJECT_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
965 3.0000 information_schema TRIGGERS EVENT_OBJECT_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
966 3.0000 information_schema TRIGGERS EVENT_OBJECT_TABLE varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
967 NULL information_schema TRIGGERS ACTION_ORDER int NULL NULL NULL NULL int unsigned
968 NULL information_schema TRIGGERS ACTION_CONDITION binary 0 0 NULL NULL binary(0)
969 1.0000 information_schema TRIGGERS ACTION_STATEMENT longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
970 3.0000 information_schema TRIGGERS ACTION_ORIENTATION varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
971 3.0000 information_schema TRIGGERS ACTION_TIMING enum 6 18 utf8mb3 utf8mb3_bin enum('BEFORE','AFTER')
972 NULL information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE binary 0 0 NULL NULL binary(0)
973 NULL information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE binary 0 0 NULL NULL binary(0)
974 3.0000 information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
975 3.0000 information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3)
976 NULL information_schema TRIGGERS CREATED timestamp NULL NULL NULL NULL timestamp(2)
977 3.0000 information_schema TRIGGERS SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL')
978 3.0000 information_schema TRIGGERS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288)
979 3.0000 information_schema TRIGGERS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
980 3.0000 information_schema TRIGGERS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
981 3.0000 information_schema TRIGGERS DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
982 3.0000 information_schema USER_ATTRIBUTES USER char 32 96 utf8mb3 utf8mb3_bin char(32)
983 1.0000 information_schema USER_ATTRIBUTES HOST char 255 255 ascii ascii_general_ci char(255)
984 1.0000 information_schema USER_ATTRIBUTES ATTRIBUTE longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext
985 3.0103 information_schema USER_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292)
986 3.0118 information_schema USER_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512)
987 3.0476 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64)
988 3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3)
989 3.0000 information_schema VIEWS TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
990 3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
991 3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
992 1.0000 information_schema VIEWS VIEW_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext
993 3.0000 information_schema VIEWS CHECK_OPTION enum 8 24 utf8mb3 utf8mb3_bin enum('NONE','LOCAL','CASCADED')
994 3.0000 information_schema VIEWS IS_UPDATABLE enum 3 9 utf8mb3 utf8mb3_bin enum('NO','YES')
995 3.0000 information_schema VIEWS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288)
996 3.0000 information_schema VIEWS SECURITY_TYPE varchar 7 21 utf8mb3 utf8mb3_bin varchar(7)
997 3.0000 information_schema VIEWS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
998 3.0000 information_schema VIEWS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
999 3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1000 3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1001 3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1002 3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1003 3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1004 3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64)
1005 3.0000 information_schema VIEW_TABLE_USAGE VIEW_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1006 3.0000 information_schema VIEW_TABLE_USAGE VIEW_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1007 3.0000 information_schema VIEW_TABLE_USAGE VIEW_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1008 3.0000 information_schema VIEW_TABLE_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1009 3.0000 information_schema VIEW_TABLE_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1010 3.0000 information_schema VIEW_TABLE_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8mb3_bin varchar(64)
1011 SET sql_mode = default;