1
SELECT * FROM information_schema.columns
2
WHERE table_schema = 'information_schema'
3
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
4
ORDER BY table_schema, table_name, column_name;
5
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 CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT STORAGE FORMAT
6
NULL information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
7
NULL information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
8
NULL information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 240 NULL NULL utf8 utf8_general_ci varchar(60) select Default Default
9
NULL information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL bigint(3) select Default Default
10
NULL information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
11
NULL information_schema COLLATIONS COLLATION_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
12
NULL information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL bigint(11) select Default Default
13
NULL information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
14
NULL information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
15
NULL information_schema COLLATIONS SORTLEN 6 0 NO bigint NULL NULL 19 0 NULL NULL bigint(3) select Default Default
16
NULL information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
17
NULL information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
18
NULL information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
19
NULL information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
20
NULL information_schema COLUMNS CHARACTER_SET_NAME 13 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
21
NULL information_schema COLUMNS COLLATION_NAME 14 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
22
NULL information_schema COLUMNS COLUMN_COMMENT 19 NO varchar 1024 4096 NULL NULL utf8 utf8_general_ci varchar(1024) select Default Default
23
NULL information_schema COLUMNS COLUMN_DEFAULT 6 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
24
NULL information_schema COLUMNS COLUMN_KEY 16 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
25
NULL information_schema COLUMNS COLUMN_NAME 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
26
NULL information_schema COLUMNS COLUMN_TYPE 15 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
27
NULL information_schema COLUMNS DATA_TYPE 8 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
28
NULL information_schema COLUMNS EXTRA 17 NO varchar 27 108 NULL NULL utf8 utf8_general_ci varchar(27) select Default Default
29
NULL information_schema COLUMNS FORMAT 21 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
30
NULL information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
31
NULL information_schema COLUMNS NUMERIC_PRECISION 11 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
32
NULL information_schema COLUMNS NUMERIC_SCALE 12 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
33
NULL information_schema COLUMNS ORDINAL_POSITION 5 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
34
NULL information_schema COLUMNS PRIVILEGES 18 NO varchar 80 320 NULL NULL utf8 utf8_general_ci varchar(80) select Default Default
35
NULL information_schema COLUMNS STORAGE 20 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
36
NULL information_schema COLUMNS TABLE_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
37
NULL information_schema COLUMNS TABLE_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
38
NULL information_schema COLUMNS TABLE_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
39
NULL information_schema COLUMN_PRIVILEGES COLUMN_NAME 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
40
NULL information_schema COLUMN_PRIVILEGES GRANTEE 1 NO varchar 81 324 NULL NULL utf8 utf8_general_ci varchar(81) select Default Default
41
NULL information_schema COLUMN_PRIVILEGES IS_GRANTABLE 7 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
42
NULL information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
43
NULL information_schema COLUMN_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
44
NULL information_schema COLUMN_PRIVILEGES TABLE_NAME 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
45
NULL information_schema COLUMN_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
46
NULL information_schema ENGINES COMMENT 3 NO varchar 80 320 NULL NULL utf8 utf8_general_ci varchar(80) select Default Default
47
NULL information_schema ENGINES ENGINE 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
48
NULL information_schema ENGINES SAVEPOINTS 6 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
49
NULL information_schema ENGINES SUPPORT 2 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
50
NULL information_schema ENGINES TRANSACTIONS 4 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
51
NULL information_schema ENGINES XA 5 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
52
NULL information_schema EVENTS CHARACTER_SET_CLIENT 22 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
53
NULL information_schema EVENTS COLLATION_CONNECTION 23 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
54
NULL information_schema EVENTS CREATED 17 0000-00-00 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
55
NULL information_schema EVENTS DATABASE_COLLATION 24 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
56
NULL information_schema EVENTS DEFINER 4 NO varchar 77 308 NULL NULL utf8 utf8_general_ci varchar(77) select Default Default
57
NULL information_schema EVENTS ENDS 14 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
58
NULL information_schema EVENTS EVENT_BODY 6 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
59
NULL information_schema EVENTS EVENT_CATALOG 1 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
60
NULL information_schema EVENTS EVENT_COMMENT 20 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
61
NULL information_schema EVENTS EVENT_DEFINITION 7 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
62
NULL information_schema EVENTS EVENT_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
63
NULL information_schema EVENTS EVENT_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
64
NULL information_schema EVENTS EVENT_TYPE 8 NO varchar 9 36 NULL NULL utf8 utf8_general_ci varchar(9) select Default Default
65
NULL information_schema EVENTS EXECUTE_AT 9 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
66
NULL information_schema EVENTS INTERVAL_FIELD 11 NULL YES varchar 18 72 NULL NULL utf8 utf8_general_ci varchar(18) select Default Default
67
NULL information_schema EVENTS INTERVAL_VALUE 10 NULL YES varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
68
NULL information_schema EVENTS LAST_ALTERED 18 0000-00-00 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
69
NULL information_schema EVENTS LAST_EXECUTED 19 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
70
NULL information_schema EVENTS ON_COMPLETION 16 NO varchar 12 48 NULL NULL utf8 utf8_general_ci varchar(12) select Default Default
71
NULL information_schema EVENTS ORIGINATOR 21 0 NO bigint NULL NULL 19 0 NULL NULL bigint(10) select Default Default
72
NULL information_schema EVENTS SQL_MODE 12 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
73
NULL information_schema EVENTS STARTS 13 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
74
NULL information_schema EVENTS STATUS 15 NO varchar 18 72 NULL NULL utf8 utf8_general_ci varchar(18) select Default Default
75
NULL information_schema EVENTS TIME_ZONE 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
76
NULL information_schema FILES AUTOEXTEND_SIZE 19 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
77
NULL information_schema FILES AVG_ROW_LENGTH 28 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
78
NULL information_schema FILES CHECKSUM 36 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
79
NULL information_schema FILES CHECK_TIME 35 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
80
NULL information_schema FILES CREATE_TIME 33 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
81
NULL information_schema FILES CREATION_TIME 20 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
82
NULL information_schema FILES DATA_FREE 32 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
83
NULL information_schema FILES DATA_LENGTH 29 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
84
NULL information_schema FILES DELETED_ROWS 12 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
85
NULL information_schema FILES ENGINE 10 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
86
NULL information_schema FILES EXTENT_SIZE 16 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
87
NULL information_schema FILES EXTRA 38 NULL YES varchar 255 1020 NULL NULL utf8 utf8_general_ci varchar(255) select Default Default
88
NULL information_schema FILES FILE_ID 1 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
89
NULL information_schema FILES FILE_NAME 2 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
90
NULL information_schema FILES FILE_TYPE 3 NO varchar 20 80 NULL NULL utf8 utf8_general_ci varchar(20) select Default Default
91
NULL information_schema FILES FREE_EXTENTS 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
92
NULL information_schema FILES FULLTEXT_KEYS 11 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
93
NULL information_schema FILES INDEX_LENGTH 31 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
94
NULL information_schema FILES INITIAL_SIZE 17 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
95
NULL information_schema FILES LAST_ACCESS_TIME 22 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
96
NULL information_schema FILES LAST_UPDATE_TIME 21 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
97
NULL information_schema FILES LOGFILE_GROUP_NAME 8 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
98
NULL information_schema FILES LOGFILE_GROUP_NUMBER 9 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
99
NULL information_schema FILES MAXIMUM_SIZE 18 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
100
NULL information_schema FILES MAX_DATA_LENGTH 30 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
101
NULL information_schema FILES RECOVER_TIME 23 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
102
NULL information_schema FILES ROW_FORMAT 26 NULL YES varchar 10 40 NULL NULL utf8 utf8_general_ci varchar(10) select Default Default
103
NULL information_schema FILES STATUS 37 NO varchar 20 80 NULL NULL utf8 utf8_general_ci varchar(20) select Default Default
104
NULL information_schema FILES TABLESPACE_NAME 4 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
105
NULL information_schema FILES TABLE_CATALOG 5 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
106
NULL information_schema FILES TABLE_NAME 7 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
107
NULL information_schema FILES TABLE_ROWS 27 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
108
NULL information_schema FILES TABLE_SCHEMA 6 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
109
NULL information_schema FILES TOTAL_EXTENTS 15 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
110
NULL information_schema FILES TRANSACTION_COUNTER 24 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
111
NULL information_schema FILES UPDATE_COUNT 13 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
112
NULL information_schema FILES UPDATE_TIME 34 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
113
NULL information_schema FILES VERSION 25 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
114
NULL information_schema GLOBAL_STATUS VARIABLE_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
115
NULL information_schema GLOBAL_STATUS VARIABLE_VALUE 2 NULL YES varchar 16300 65200 NULL NULL utf8 utf8_general_ci varchar(16300) select Default Default
116
NULL information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
117
NULL information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 16300 65200 NULL NULL utf8 utf8_general_ci varchar(16300) select Default Default
118
NULL information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
119
NULL information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
120
NULL information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
121
NULL information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
122
NULL information_schema KEY_COLUMN_USAGE ORDINAL_POSITION 8 0 NO bigint NULL NULL 19 0 NULL NULL bigint(10) select Default Default
123
NULL information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT 9 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(10) select Default Default
124
NULL information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME 12 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
125
NULL information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME 11 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
126
NULL information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA 10 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
127
NULL information_schema KEY_COLUMN_USAGE TABLE_CATALOG 4 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
128
NULL information_schema KEY_COLUMN_USAGE TABLE_NAME 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
129
NULL information_schema KEY_COLUMN_USAGE TABLE_SCHEMA 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
130
NULL information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH 8 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
131
NULL information_schema PARAMETERS CHARACTER_OCTET_LENGTH 9 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
132
NULL information_schema PARAMETERS CHARACTER_SET_NAME 12 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
133
NULL information_schema PARAMETERS COLLATION_NAME 13 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
134
NULL information_schema PARAMETERS DATA_TYPE 7 NO varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
135
NULL information_schema PARAMETERS DTD_IDENTIFIER 14 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
136
NULL information_schema PARAMETERS NUMERIC_PRECISION 10 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
137
NULL information_schema PARAMETERS NUMERIC_SCALE 11 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
138
NULL information_schema PARAMETERS ORDINAL_POSITION 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select Default Default
139
NULL information_schema PARAMETERS PARAMETER_MODE 5 NULL YES varchar 5 20 NULL NULL utf8 utf8_general_ci varchar(5) select Default Default
140
NULL information_schema PARAMETERS PARAMETER_NAME 6 NULL YES varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
141
NULL information_schema PARAMETERS SPECIFIC_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
142
NULL information_schema PARAMETERS SPECIFIC_NAME 3 NO varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
143
NULL information_schema PARAMETERS SPECIFIC_SCHEMA 2 NO varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
144
NULL information_schema PARTITIONS AVG_ROW_LENGTH 14 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
145
NULL information_schema PARTITIONS CHECKSUM 22 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
146
NULL information_schema PARTITIONS CHECK_TIME 21 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
147
NULL information_schema PARTITIONS CREATE_TIME 19 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
148
NULL information_schema PARTITIONS DATA_FREE 18 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
149
NULL information_schema PARTITIONS DATA_LENGTH 15 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
150
NULL information_schema PARTITIONS INDEX_LENGTH 17 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
151
NULL information_schema PARTITIONS MAX_DATA_LENGTH 16 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
152
NULL information_schema PARTITIONS NODEGROUP 24 NO varchar 12 48 NULL NULL utf8 utf8_general_ci varchar(12) select Default Default
153
NULL information_schema PARTITIONS PARTITION_COMMENT 23 NO varchar 80 320 NULL NULL utf8 utf8_general_ci varchar(80) select Default Default
154
NULL information_schema PARTITIONS PARTITION_DESCRIPTION 12 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
155
NULL information_schema PARTITIONS PARTITION_EXPRESSION 10 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
156
NULL information_schema PARTITIONS PARTITION_METHOD 8 NULL YES varchar 12 48 NULL NULL utf8 utf8_general_ci varchar(12) select Default Default
157
NULL information_schema PARTITIONS PARTITION_NAME 4 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
158
NULL information_schema PARTITIONS PARTITION_ORDINAL_POSITION 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
159
NULL information_schema PARTITIONS SUBPARTITION_EXPRESSION 11 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
160
NULL information_schema PARTITIONS SUBPARTITION_METHOD 9 NULL YES varchar 12 48 NULL NULL utf8 utf8_general_ci varchar(12) select Default Default
161
NULL information_schema PARTITIONS SUBPARTITION_NAME 5 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
162
NULL information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
163
NULL information_schema PARTITIONS TABLESPACE_NAME 25 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
164
NULL information_schema PARTITIONS TABLE_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
165
NULL information_schema PARTITIONS TABLE_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
166
NULL information_schema PARTITIONS TABLE_ROWS 13 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
167
NULL information_schema PARTITIONS TABLE_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
168
NULL information_schema PARTITIONS UPDATE_TIME 20 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
169
NULL information_schema PLUGINS PLUGIN_AUTHOR 8 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
170
NULL information_schema PLUGINS PLUGIN_DESCRIPTION 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
171
NULL information_schema PLUGINS PLUGIN_LIBRARY 6 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
172
NULL information_schema PLUGINS PLUGIN_LIBRARY_VERSION 7 NULL YES varchar 20 80 NULL NULL utf8 utf8_general_ci varchar(20) select Default Default
173
NULL information_schema PLUGINS PLUGIN_LICENSE 10 NULL YES varchar 80 320 NULL NULL utf8 utf8_general_ci varchar(80) select Default Default
174
NULL information_schema PLUGINS PLUGIN_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
175
NULL information_schema PLUGINS PLUGIN_STATUS 3 NO varchar 10 40 NULL NULL utf8 utf8_general_ci varchar(10) select Default Default
176
NULL information_schema PLUGINS PLUGIN_TYPE 4 NO varchar 80 320 NULL NULL utf8 utf8_general_ci varchar(80) select Default Default
177
NULL information_schema PLUGINS PLUGIN_TYPE_VERSION 5 NO varchar 20 80 NULL NULL utf8 utf8_general_ci varchar(20) select Default Default
178
NULL information_schema PLUGINS PLUGIN_VERSION 2 NO varchar 20 80 NULL NULL utf8 utf8_general_ci varchar(20) select Default Default
179
NULL information_schema PROCESSLIST COMMAND 5 NO varchar 16 64 NULL NULL utf8 utf8_general_ci varchar(16) select Default Default
180
NULL information_schema PROCESSLIST DB 4 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
181
NULL information_schema PROCESSLIST HOST 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
182
NULL information_schema PROCESSLIST ID 1 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
183
NULL information_schema PROCESSLIST INFO 8 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
184
NULL information_schema PROCESSLIST STATE 7 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
185
NULL information_schema PROCESSLIST TIME 6 0 NO bigint NULL NULL 19 0 NULL NULL bigint(7) select Default Default
186
NULL information_schema PROCESSLIST USER 2 NO varchar 16 64 NULL NULL utf8 utf8_general_ci varchar(16) select Default Default
187
NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
188
NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
189
NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
190
NULL information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE 9 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
191
NULL information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION 7 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
192
NULL information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME 11 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
193
NULL information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME 10 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
194
NULL information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG 4 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
195
NULL information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
196
NULL information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
197
NULL information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE 8 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
198
NULL information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH 7 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
199
NULL information_schema ROUTINES CHARACTER_OCTET_LENGTH 8 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
200
NULL information_schema ROUTINES CHARACTER_SET_CLIENT 28 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
201
NULL information_schema ROUTINES CHARACTER_SET_NAME 11 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
202
NULL information_schema ROUTINES COLLATION_CONNECTION 29 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
203
NULL information_schema ROUTINES COLLATION_NAME 12 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
204
NULL information_schema ROUTINES CREATED 23 0000-00-00 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
205
NULL information_schema ROUTINES DATABASE_COLLATION 30 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
206
NULL information_schema ROUTINES DATA_TYPE 6 NO varchar 256 1024 NULL NULL utf8 utf8_general_ci varchar(256) select Default Default
207
NULL information_schema ROUTINES DEFINER 27 NO varchar 77 308 NULL NULL utf8 utf8_general_ci varchar(77) select Default Default
208
NULL information_schema ROUTINES DTD_IDENTIFIER 13 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
209
NULL information_schema ROUTINES EXTERNAL_LANGUAGE 17 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
210
NULL information_schema ROUTINES EXTERNAL_NAME 16 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
211
NULL information_schema ROUTINES IS_DETERMINISTIC 19 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
212
NULL information_schema ROUTINES LAST_ALTERED 24 0000-00-00 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
213
NULL information_schema ROUTINES NUMERIC_PRECISION 9 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
214
NULL information_schema ROUTINES NUMERIC_SCALE 10 NULL YES int NULL NULL 10 0 NULL NULL int(21) select Default Default
215
NULL information_schema ROUTINES PARAMETER_STYLE 18 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
216
NULL information_schema ROUTINES ROUTINE_BODY 14 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
217
NULL information_schema ROUTINES ROUTINE_CATALOG 2 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
218
NULL information_schema ROUTINES ROUTINE_COMMENT 26 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
219
NULL information_schema ROUTINES ROUTINE_DEFINITION 15 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
220
NULL information_schema ROUTINES ROUTINE_NAME 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
221
NULL information_schema ROUTINES ROUTINE_SCHEMA 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
222
NULL information_schema ROUTINES ROUTINE_TYPE 5 NO varchar 9 36 NULL NULL utf8 utf8_general_ci varchar(9) select Default Default
223
NULL information_schema ROUTINES SECURITY_TYPE 22 NO varchar 7 28 NULL NULL utf8 utf8_general_ci varchar(7) select Default Default
224
NULL information_schema ROUTINES SPECIFIC_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
225
NULL information_schema ROUTINES SQL_DATA_ACCESS 20 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
226
NULL information_schema ROUTINES SQL_MODE 25 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
227
NULL information_schema ROUTINES SQL_PATH 21 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
228
NULL information_schema SCHEMATA CATALOG_NAME 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
229
NULL information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
230
NULL information_schema SCHEMATA DEFAULT_COLLATION_NAME 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
231
NULL information_schema SCHEMATA SCHEMA_NAME 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
232
NULL information_schema SCHEMATA SQL_PATH 5 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
233
NULL information_schema SCHEMA_PRIVILEGES GRANTEE 1 NO varchar 81 324 NULL NULL utf8 utf8_general_ci varchar(81) select Default Default
234
NULL information_schema SCHEMA_PRIVILEGES IS_GRANTABLE 5 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
235
NULL information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
236
NULL information_schema SCHEMA_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
237
NULL information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
238
NULL information_schema SESSION_STATUS VARIABLE_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
239
NULL information_schema SESSION_STATUS VARIABLE_VALUE 2 NULL YES varchar 16300 65200 NULL NULL utf8 utf8_general_ci varchar(16300) select Default Default
240
NULL information_schema SESSION_VARIABLES VARIABLE_NAME 1 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
241
NULL information_schema SESSION_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 16300 65200 NULL NULL utf8 utf8_general_ci varchar(16300) select Default Default
242
NULL information_schema STATISTICS CARDINALITY 10 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) select Default Default
243
NULL information_schema STATISTICS COLLATION 9 NULL YES varchar 1 4 NULL NULL utf8 utf8_general_ci varchar(1) select Default Default
244
NULL information_schema STATISTICS COLUMN_NAME 8 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
245
NULL information_schema STATISTICS COMMENT 15 NULL YES varchar 16 64 NULL NULL utf8 utf8_general_ci varchar(16) select Default Default
246
NULL information_schema STATISTICS INDEX_COMMENT 16 NO varchar 1024 4096 NULL NULL utf8 utf8_general_ci varchar(1024) select Default Default
247
NULL information_schema STATISTICS INDEX_NAME 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
248
NULL information_schema STATISTICS INDEX_SCHEMA 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
249
NULL information_schema STATISTICS INDEX_TYPE 14 NO varchar 16 64 NULL NULL utf8 utf8_general_ci varchar(16) select Default Default
250
NULL information_schema STATISTICS NON_UNIQUE 4 0 NO bigint NULL NULL 19 0 NULL NULL bigint(1) select Default Default
251
NULL information_schema STATISTICS NULLABLE 13 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
252
NULL information_schema STATISTICS PACKED 12 NULL YES varchar 10 40 NULL NULL utf8 utf8_general_ci varchar(10) select Default Default
253
NULL information_schema STATISTICS SEQ_IN_INDEX 7 0 NO bigint NULL NULL 19 0 NULL NULL bigint(2) select Default Default
254
NULL information_schema STATISTICS SUB_PART 11 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(3) select Default Default
255
NULL information_schema STATISTICS TABLE_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
256
NULL information_schema STATISTICS TABLE_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
257
NULL information_schema STATISTICS TABLE_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
258
NULL information_schema TABLES AUTO_INCREMENT 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
259
NULL information_schema TABLES AVG_ROW_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
260
NULL information_schema TABLES CHECKSUM 19 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
261
NULL information_schema TABLES CHECK_TIME 17 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
262
NULL information_schema TABLES CREATE_OPTIONS 20 NULL YES varchar 255 1020 NULL NULL utf8 utf8_general_ci varchar(255) select Default Default
263
NULL information_schema TABLES CREATE_TIME 15 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
264
NULL information_schema TABLES DATA_FREE 13 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
265
NULL information_schema TABLES DATA_LENGTH 10 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
266
NULL information_schema TABLES ENGINE 5 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
267
NULL information_schema TABLES INDEX_LENGTH 12 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
268
NULL information_schema TABLES MAX_DATA_LENGTH 11 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
269
NULL information_schema TABLES ROW_FORMAT 7 NULL YES varchar 10 40 NULL NULL utf8 utf8_general_ci varchar(10) select Default Default
270
NULL information_schema TABLES TABLE_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
271
NULL information_schema TABLES TABLE_COLLATION 18 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
272
NULL information_schema TABLES TABLE_COMMENT 21 NO varchar 2048 8192 NULL NULL utf8 utf8_general_ci varchar(2048) select Default Default
273
NULL information_schema TABLES TABLE_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
274
NULL information_schema TABLES TABLE_ROWS 8 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
275
NULL information_schema TABLES TABLE_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
276
NULL information_schema TABLES TABLE_TYPE 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
277
NULL information_schema TABLES UPDATE_TIME 16 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
278
NULL information_schema TABLES VERSION 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(21) unsigned select Default Default
279
NULL information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
280
NULL information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
281
NULL information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
282
NULL information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
283
NULL information_schema TABLE_CONSTRAINTS TABLE_NAME 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
284
NULL information_schema TABLE_CONSTRAINTS TABLE_SCHEMA 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
285
NULL information_schema TABLE_PRIVILEGES GRANTEE 1 NO varchar 81 324 NULL NULL utf8 utf8_general_ci varchar(81) select Default Default
286
NULL information_schema TABLE_PRIVILEGES IS_GRANTABLE 6 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
287
NULL information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE 5 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
288
NULL information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
289
NULL information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
290
NULL information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
291
NULL information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
292
NULL information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
293
NULL information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 36 NULL NULL utf8 utf8_general_ci varchar(9) select Default Default
294
NULL information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW 16 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
295
NULL information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE 14 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
296
NULL information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW 15 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
297
NULL information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE 13 NULL YES varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
298
NULL information_schema TRIGGERS ACTION_STATEMENT 10 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
299
NULL information_schema TRIGGERS ACTION_TIMING 12 NO varchar 6 24 NULL NULL utf8 utf8_general_ci varchar(6) select Default Default
300
NULL information_schema TRIGGERS CHARACTER_SET_CLIENT 20 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
301
NULL information_schema TRIGGERS COLLATION_CONNECTION 21 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
302
NULL information_schema TRIGGERS CREATED 17 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select Default Default
303
NULL information_schema TRIGGERS DATABASE_COLLATION 22 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
304
NULL information_schema TRIGGERS DEFINER 19 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
305
NULL information_schema TRIGGERS EVENT_MANIPULATION 4 NO varchar 6 24 NULL NULL utf8 utf8_general_ci varchar(6) select Default Default
306
NULL information_schema TRIGGERS EVENT_OBJECT_CATALOG 5 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
307
NULL information_schema TRIGGERS EVENT_OBJECT_SCHEMA 6 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
308
NULL information_schema TRIGGERS EVENT_OBJECT_TABLE 7 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
309
NULL information_schema TRIGGERS SQL_MODE 18 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
310
NULL information_schema TRIGGERS TRIGGER_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
311
NULL information_schema TRIGGERS TRIGGER_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
312
NULL information_schema TRIGGERS TRIGGER_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
313
NULL information_schema USER_PRIVILEGES GRANTEE 1 NO varchar 81 324 NULL NULL utf8 utf8_general_ci varchar(81) select Default Default
314
NULL information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
315
NULL information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
316
NULL information_schema USER_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
317
NULL information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
318
NULL information_schema VIEWS CHECK_OPTION 5 NO varchar 8 32 NULL NULL utf8 utf8_general_ci varchar(8) select Default Default
319
NULL information_schema VIEWS COLLATION_CONNECTION 10 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
320
NULL information_schema VIEWS DEFINER 7 NO varchar 77 308 NULL NULL utf8 utf8_general_ci varchar(77) select Default Default
321
NULL information_schema VIEWS IS_UPDATABLE 6 NO varchar 3 12 NULL NULL utf8 utf8_general_ci varchar(3) select Default Default
322
NULL information_schema VIEWS SECURITY_TYPE 8 NO varchar 7 28 NULL NULL utf8 utf8_general_ci varchar(7) select Default Default
323
NULL information_schema VIEWS TABLE_CATALOG 1 NULL YES varchar 512 2048 NULL NULL utf8 utf8_general_ci varchar(512) select Default Default
324
NULL information_schema VIEWS TABLE_NAME 3 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
325
NULL information_schema VIEWS TABLE_SCHEMA 2 NO varchar 64 256 NULL NULL utf8 utf8_general_ci varchar(64) select Default Default
326
NULL information_schema VIEWS VIEW_DEFINITION 4 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select Default Default
327
##########################################################################
328
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
329
##########################################################################
331
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
335
FROM information_schema.columns
336
WHERE table_schema = 'information_schema'
337
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
338
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
339
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
340
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
341
1.0000 longtext utf8 utf8_general_ci
343
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
347
FROM information_schema.columns
348
WHERE table_schema = 'information_schema'
349
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
350
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1
351
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
352
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
353
4.0000 varchar utf8 utf8_general_ci
355
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
359
FROM information_schema.columns
360
WHERE table_schema = 'information_schema'
361
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
362
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL
363
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
364
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
365
NULL bigint NULL NULL
366
NULL datetime NULL NULL
368
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values
369
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL
370
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
375
CHARACTER_MAXIMUM_LENGTH,
376
CHARACTER_OCTET_LENGTH,
380
FROM information_schema.columns
381
WHERE table_schema = 'information_schema'
382
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
383
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
384
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
385
4.0000 information_schema CHARACTER_SETS CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
386
4.0000 information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
387
4.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 240 utf8 utf8_general_ci varchar(60)
388
NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3)
389
4.0000 information_schema COLLATIONS COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
390
4.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
391
NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11)
392
4.0000 information_schema COLLATIONS IS_DEFAULT varchar 3 12 utf8 utf8_general_ci varchar(3)
393
4.0000 information_schema COLLATIONS IS_COMPILED varchar 3 12 utf8 utf8_general_ci varchar(3)
394
NULL information_schema COLLATIONS SORTLEN bigint NULL NULL NULL NULL bigint(3)
395
4.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
396
4.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
397
4.0000 information_schema COLUMNS TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
398
4.0000 information_schema COLUMNS TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
399
4.0000 information_schema COLUMNS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
400
4.0000 information_schema COLUMNS COLUMN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
401
NULL information_schema COLUMNS ORDINAL_POSITION bigint NULL NULL NULL NULL bigint(21) unsigned
402
1.0000 information_schema COLUMNS COLUMN_DEFAULT longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
403
4.0000 information_schema COLUMNS IS_NULLABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
404
4.0000 information_schema COLUMNS DATA_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
405
NULL information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
406
NULL information_schema COLUMNS CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
407
NULL information_schema COLUMNS NUMERIC_PRECISION bigint NULL NULL NULL NULL bigint(21) unsigned
408
NULL information_schema COLUMNS NUMERIC_SCALE bigint NULL NULL NULL NULL bigint(21) unsigned
409
4.0000 information_schema COLUMNS CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
410
4.0000 information_schema COLUMNS COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
411
1.0000 information_schema COLUMNS COLUMN_TYPE longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
412
4.0000 information_schema COLUMNS COLUMN_KEY varchar 3 12 utf8 utf8_general_ci varchar(3)
413
4.0000 information_schema COLUMNS EXTRA varchar 27 108 utf8 utf8_general_ci varchar(27)
414
4.0000 information_schema COLUMNS PRIVILEGES varchar 80 320 utf8 utf8_general_ci varchar(80)
415
4.0000 information_schema COLUMNS COLUMN_COMMENT varchar 1024 4096 utf8 utf8_general_ci varchar(1024)
416
4.0000 information_schema COLUMNS STORAGE varchar 8 32 utf8 utf8_general_ci varchar(8)
417
4.0000 information_schema COLUMNS FORMAT varchar 8 32 utf8 utf8_general_ci varchar(8)
418
4.0000 information_schema COLUMN_PRIVILEGES GRANTEE varchar 81 324 utf8 utf8_general_ci varchar(81)
419
4.0000 information_schema COLUMN_PRIVILEGES TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
420
4.0000 information_schema COLUMN_PRIVILEGES TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
421
4.0000 information_schema COLUMN_PRIVILEGES TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
422
4.0000 information_schema COLUMN_PRIVILEGES COLUMN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
423
4.0000 information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
424
4.0000 information_schema COLUMN_PRIVILEGES IS_GRANTABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
425
4.0000 information_schema ENGINES ENGINE varchar 64 256 utf8 utf8_general_ci varchar(64)
426
4.0000 information_schema ENGINES SUPPORT varchar 8 32 utf8 utf8_general_ci varchar(8)
427
4.0000 information_schema ENGINES COMMENT varchar 80 320 utf8 utf8_general_ci varchar(80)
428
4.0000 information_schema ENGINES TRANSACTIONS varchar 3 12 utf8 utf8_general_ci varchar(3)
429
4.0000 information_schema ENGINES XA varchar 3 12 utf8 utf8_general_ci varchar(3)
430
4.0000 information_schema ENGINES SAVEPOINTS varchar 3 12 utf8 utf8_general_ci varchar(3)
431
4.0000 information_schema EVENTS EVENT_CATALOG varchar 64 256 utf8 utf8_general_ci varchar(64)
432
4.0000 information_schema EVENTS EVENT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
433
4.0000 information_schema EVENTS EVENT_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
434
4.0000 information_schema EVENTS DEFINER varchar 77 308 utf8 utf8_general_ci varchar(77)
435
4.0000 information_schema EVENTS TIME_ZONE varchar 64 256 utf8 utf8_general_ci varchar(64)
436
4.0000 information_schema EVENTS EVENT_BODY varchar 8 32 utf8 utf8_general_ci varchar(8)
437
1.0000 information_schema EVENTS EVENT_DEFINITION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
438
4.0000 information_schema EVENTS EVENT_TYPE varchar 9 36 utf8 utf8_general_ci varchar(9)
439
NULL information_schema EVENTS EXECUTE_AT datetime NULL NULL NULL NULL datetime
440
4.0000 information_schema EVENTS INTERVAL_VALUE varchar 256 1024 utf8 utf8_general_ci varchar(256)
441
4.0000 information_schema EVENTS INTERVAL_FIELD varchar 18 72 utf8 utf8_general_ci varchar(18)
442
1.0000 information_schema EVENTS SQL_MODE longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
443
NULL information_schema EVENTS STARTS datetime NULL NULL NULL NULL datetime
444
NULL information_schema EVENTS ENDS datetime NULL NULL NULL NULL datetime
445
4.0000 information_schema EVENTS STATUS varchar 18 72 utf8 utf8_general_ci varchar(18)
446
4.0000 information_schema EVENTS ON_COMPLETION varchar 12 48 utf8 utf8_general_ci varchar(12)
447
NULL information_schema EVENTS CREATED datetime NULL NULL NULL NULL datetime
448
NULL information_schema EVENTS LAST_ALTERED datetime NULL NULL NULL NULL datetime
449
NULL information_schema EVENTS LAST_EXECUTED datetime NULL NULL NULL NULL datetime
450
4.0000 information_schema EVENTS EVENT_COMMENT varchar 64 256 utf8 utf8_general_ci varchar(64)
451
NULL information_schema EVENTS ORIGINATOR bigint NULL NULL NULL NULL bigint(10)
452
4.0000 information_schema EVENTS CHARACTER_SET_CLIENT varchar 32 128 utf8 utf8_general_ci varchar(32)
453
4.0000 information_schema EVENTS COLLATION_CONNECTION varchar 32 128 utf8 utf8_general_ci varchar(32)
454
4.0000 information_schema EVENTS DATABASE_COLLATION varchar 32 128 utf8 utf8_general_ci varchar(32)
455
NULL information_schema FILES FILE_ID bigint NULL NULL NULL NULL bigint(4)
456
4.0000 information_schema FILES FILE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
457
4.0000 information_schema FILES FILE_TYPE varchar 20 80 utf8 utf8_general_ci varchar(20)
458
4.0000 information_schema FILES TABLESPACE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
459
4.0000 information_schema FILES TABLE_CATALOG varchar 64 256 utf8 utf8_general_ci varchar(64)
460
4.0000 information_schema FILES TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
461
4.0000 information_schema FILES TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
462
4.0000 information_schema FILES LOGFILE_GROUP_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
463
NULL information_schema FILES LOGFILE_GROUP_NUMBER bigint NULL NULL NULL NULL bigint(4)
464
4.0000 information_schema FILES ENGINE varchar 64 256 utf8 utf8_general_ci varchar(64)
465
4.0000 information_schema FILES FULLTEXT_KEYS varchar 64 256 utf8 utf8_general_ci varchar(64)
466
NULL information_schema FILES DELETED_ROWS bigint NULL NULL NULL NULL bigint(4)
467
NULL information_schema FILES UPDATE_COUNT bigint NULL NULL NULL NULL bigint(4)
468
NULL information_schema FILES FREE_EXTENTS bigint NULL NULL NULL NULL bigint(4)
469
NULL information_schema FILES TOTAL_EXTENTS bigint NULL NULL NULL NULL bigint(4)
470
NULL information_schema FILES EXTENT_SIZE bigint NULL NULL NULL NULL bigint(4)
471
NULL information_schema FILES INITIAL_SIZE bigint NULL NULL NULL NULL bigint(21) unsigned
472
NULL information_schema FILES MAXIMUM_SIZE bigint NULL NULL NULL NULL bigint(21) unsigned
473
NULL information_schema FILES AUTOEXTEND_SIZE bigint NULL NULL NULL NULL bigint(21) unsigned
474
NULL information_schema FILES CREATION_TIME datetime NULL NULL NULL NULL datetime
475
NULL information_schema FILES LAST_UPDATE_TIME datetime NULL NULL NULL NULL datetime
476
NULL information_schema FILES LAST_ACCESS_TIME datetime NULL NULL NULL NULL datetime
477
NULL information_schema FILES RECOVER_TIME bigint NULL NULL NULL NULL bigint(4)
478
NULL information_schema FILES TRANSACTION_COUNTER bigint NULL NULL NULL NULL bigint(4)
479
NULL information_schema FILES VERSION bigint NULL NULL NULL NULL bigint(21) unsigned
480
4.0000 information_schema FILES ROW_FORMAT varchar 10 40 utf8 utf8_general_ci varchar(10)
481
NULL information_schema FILES TABLE_ROWS bigint NULL NULL NULL NULL bigint(21) unsigned
482
NULL information_schema FILES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
483
NULL information_schema FILES DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
484
NULL information_schema FILES MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
485
NULL information_schema FILES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
486
NULL information_schema FILES DATA_FREE bigint NULL NULL NULL NULL bigint(21) unsigned
487
NULL information_schema FILES CREATE_TIME datetime NULL NULL NULL NULL datetime
488
NULL information_schema FILES UPDATE_TIME datetime NULL NULL NULL NULL datetime
489
NULL information_schema FILES CHECK_TIME datetime NULL NULL NULL NULL datetime
490
NULL information_schema FILES CHECKSUM bigint NULL NULL NULL NULL bigint(21) unsigned
491
4.0000 information_schema FILES STATUS varchar 20 80 utf8 utf8_general_ci varchar(20)
492
4.0000 information_schema FILES EXTRA varchar 255 1020 utf8 utf8_general_ci varchar(255)
493
4.0000 information_schema GLOBAL_STATUS VARIABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
494
4.0000 information_schema GLOBAL_STATUS VARIABLE_VALUE varchar 16300 65200 utf8 utf8_general_ci varchar(16300)
495
4.0000 information_schema GLOBAL_VARIABLES VARIABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
496
4.0000 information_schema GLOBAL_VARIABLES VARIABLE_VALUE varchar 16300 65200 utf8 utf8_general_ci varchar(16300)
497
4.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
498
4.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
499
4.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
500
4.0000 information_schema KEY_COLUMN_USAGE TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
501
4.0000 information_schema KEY_COLUMN_USAGE TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
502
4.0000 information_schema KEY_COLUMN_USAGE TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
503
4.0000 information_schema KEY_COLUMN_USAGE COLUMN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
504
NULL information_schema KEY_COLUMN_USAGE ORDINAL_POSITION bigint NULL NULL NULL NULL bigint(10)
505
NULL information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT bigint NULL NULL NULL NULL bigint(10)
506
4.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
507
4.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
508
4.0000 information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
509
4.0000 information_schema PARAMETERS SPECIFIC_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
510
4.0000 information_schema PARAMETERS SPECIFIC_SCHEMA varchar 256 1024 utf8 utf8_general_ci varchar(256)
511
4.0000 information_schema PARAMETERS SPECIFIC_NAME varchar 256 1024 utf8 utf8_general_ci varchar(256)
512
NULL information_schema PARAMETERS ORDINAL_POSITION int NULL NULL NULL NULL int(21)
513
4.0000 information_schema PARAMETERS PARAMETER_MODE varchar 5 20 utf8 utf8_general_ci varchar(5)
514
4.0000 information_schema PARAMETERS PARAMETER_NAME varchar 256 1024 utf8 utf8_general_ci varchar(256)
515
4.0000 information_schema PARAMETERS DATA_TYPE varchar 256 1024 utf8 utf8_general_ci varchar(256)
516
NULL information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH int NULL NULL NULL NULL int(21)
517
NULL information_schema PARAMETERS CHARACTER_OCTET_LENGTH int NULL NULL NULL NULL int(21)
518
NULL information_schema PARAMETERS NUMERIC_PRECISION int NULL NULL NULL NULL int(21)
519
NULL information_schema PARAMETERS NUMERIC_SCALE int NULL NULL NULL NULL int(21)
520
4.0000 information_schema PARAMETERS CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
521
4.0000 information_schema PARAMETERS COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
522
1.0000 information_schema PARAMETERS DTD_IDENTIFIER longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
523
4.0000 information_schema PARTITIONS TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
524
4.0000 information_schema PARTITIONS TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
525
4.0000 information_schema PARTITIONS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
526
4.0000 information_schema PARTITIONS PARTITION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
527
4.0000 information_schema PARTITIONS SUBPARTITION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
528
NULL information_schema PARTITIONS PARTITION_ORDINAL_POSITION bigint NULL NULL NULL NULL bigint(21) unsigned
529
NULL information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION bigint NULL NULL NULL NULL bigint(21) unsigned
530
4.0000 information_schema PARTITIONS PARTITION_METHOD varchar 12 48 utf8 utf8_general_ci varchar(12)
531
4.0000 information_schema PARTITIONS SUBPARTITION_METHOD varchar 12 48 utf8 utf8_general_ci varchar(12)
532
1.0000 information_schema PARTITIONS PARTITION_EXPRESSION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
533
1.0000 information_schema PARTITIONS SUBPARTITION_EXPRESSION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
534
1.0000 information_schema PARTITIONS PARTITION_DESCRIPTION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
535
NULL information_schema PARTITIONS TABLE_ROWS bigint NULL NULL NULL NULL bigint(21) unsigned
536
NULL information_schema PARTITIONS AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
537
NULL information_schema PARTITIONS DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
538
NULL information_schema PARTITIONS MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
539
NULL information_schema PARTITIONS INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
540
NULL information_schema PARTITIONS DATA_FREE bigint NULL NULL NULL NULL bigint(21) unsigned
541
NULL information_schema PARTITIONS CREATE_TIME datetime NULL NULL NULL NULL datetime
542
NULL information_schema PARTITIONS UPDATE_TIME datetime NULL NULL NULL NULL datetime
543
NULL information_schema PARTITIONS CHECK_TIME datetime NULL NULL NULL NULL datetime
544
NULL information_schema PARTITIONS CHECKSUM bigint NULL NULL NULL NULL bigint(21) unsigned
545
4.0000 information_schema PARTITIONS PARTITION_COMMENT varchar 80 320 utf8 utf8_general_ci varchar(80)
546
4.0000 information_schema PARTITIONS NODEGROUP varchar 12 48 utf8 utf8_general_ci varchar(12)
547
4.0000 information_schema PARTITIONS TABLESPACE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
548
4.0000 information_schema PLUGINS PLUGIN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
549
4.0000 information_schema PLUGINS PLUGIN_VERSION varchar 20 80 utf8 utf8_general_ci varchar(20)
550
4.0000 information_schema PLUGINS PLUGIN_STATUS varchar 10 40 utf8 utf8_general_ci varchar(10)
551
4.0000 information_schema PLUGINS PLUGIN_TYPE varchar 80 320 utf8 utf8_general_ci varchar(80)
552
4.0000 information_schema PLUGINS PLUGIN_TYPE_VERSION varchar 20 80 utf8 utf8_general_ci varchar(20)
553
4.0000 information_schema PLUGINS PLUGIN_LIBRARY varchar 64 256 utf8 utf8_general_ci varchar(64)
554
4.0000 information_schema PLUGINS PLUGIN_LIBRARY_VERSION varchar 20 80 utf8 utf8_general_ci varchar(20)
555
4.0000 information_schema PLUGINS PLUGIN_AUTHOR varchar 64 256 utf8 utf8_general_ci varchar(64)
556
1.0000 information_schema PLUGINS PLUGIN_DESCRIPTION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
557
4.0000 information_schema PLUGINS PLUGIN_LICENSE varchar 80 320 utf8 utf8_general_ci varchar(80)
558
NULL information_schema PROCESSLIST ID bigint NULL NULL NULL NULL bigint(4)
559
4.0000 information_schema PROCESSLIST USER varchar 16 64 utf8 utf8_general_ci varchar(16)
560
4.0000 information_schema PROCESSLIST HOST varchar 64 256 utf8 utf8_general_ci varchar(64)
561
4.0000 information_schema PROCESSLIST DB varchar 64 256 utf8 utf8_general_ci varchar(64)
562
4.0000 information_schema PROCESSLIST COMMAND varchar 16 64 utf8 utf8_general_ci varchar(16)
563
NULL information_schema PROCESSLIST TIME bigint NULL NULL NULL NULL bigint(7)
564
4.0000 information_schema PROCESSLIST STATE varchar 64 256 utf8 utf8_general_ci varchar(64)
565
1.0000 information_schema PROCESSLIST INFO longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
566
4.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
567
4.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
568
4.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
569
4.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
570
4.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
571
4.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
572
4.0000 information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION varchar 64 256 utf8 utf8_general_ci varchar(64)
573
4.0000 information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE varchar 64 256 utf8 utf8_general_ci varchar(64)
574
4.0000 information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE varchar 64 256 utf8 utf8_general_ci varchar(64)
575
4.0000 information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
576
4.0000 information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
577
4.0000 information_schema ROUTINES SPECIFIC_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
578
4.0000 information_schema ROUTINES ROUTINE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
579
4.0000 information_schema ROUTINES ROUTINE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
580
4.0000 information_schema ROUTINES ROUTINE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
581
4.0000 information_schema ROUTINES ROUTINE_TYPE varchar 9 36 utf8 utf8_general_ci varchar(9)
582
4.0000 information_schema ROUTINES DATA_TYPE varchar 256 1024 utf8 utf8_general_ci varchar(256)
583
NULL information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH int NULL NULL NULL NULL int(21)
584
NULL information_schema ROUTINES CHARACTER_OCTET_LENGTH int NULL NULL NULL NULL int(21)
585
NULL information_schema ROUTINES NUMERIC_PRECISION int NULL NULL NULL NULL int(21)
586
NULL information_schema ROUTINES NUMERIC_SCALE int NULL NULL NULL NULL int(21)
587
4.0000 information_schema ROUTINES CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
588
4.0000 information_schema ROUTINES COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
589
1.0000 information_schema ROUTINES DTD_IDENTIFIER longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
590
4.0000 information_schema ROUTINES ROUTINE_BODY varchar 8 32 utf8 utf8_general_ci varchar(8)
591
1.0000 information_schema ROUTINES ROUTINE_DEFINITION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
592
4.0000 information_schema ROUTINES EXTERNAL_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
593
4.0000 information_schema ROUTINES EXTERNAL_LANGUAGE varchar 64 256 utf8 utf8_general_ci varchar(64)
594
4.0000 information_schema ROUTINES PARAMETER_STYLE varchar 8 32 utf8 utf8_general_ci varchar(8)
595
4.0000 information_schema ROUTINES IS_DETERMINISTIC varchar 3 12 utf8 utf8_general_ci varchar(3)
596
4.0000 information_schema ROUTINES SQL_DATA_ACCESS varchar 64 256 utf8 utf8_general_ci varchar(64)
597
4.0000 information_schema ROUTINES SQL_PATH varchar 64 256 utf8 utf8_general_ci varchar(64)
598
4.0000 information_schema ROUTINES SECURITY_TYPE varchar 7 28 utf8 utf8_general_ci varchar(7)
599
NULL information_schema ROUTINES CREATED datetime NULL NULL NULL NULL datetime
600
NULL information_schema ROUTINES LAST_ALTERED datetime NULL NULL NULL NULL datetime
601
1.0000 information_schema ROUTINES SQL_MODE longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
602
4.0000 information_schema ROUTINES ROUTINE_COMMENT varchar 64 256 utf8 utf8_general_ci varchar(64)
603
4.0000 information_schema ROUTINES DEFINER varchar 77 308 utf8 utf8_general_ci varchar(77)
604
4.0000 information_schema ROUTINES CHARACTER_SET_CLIENT varchar 32 128 utf8 utf8_general_ci varchar(32)
605
4.0000 information_schema ROUTINES COLLATION_CONNECTION varchar 32 128 utf8 utf8_general_ci varchar(32)
606
4.0000 information_schema ROUTINES DATABASE_COLLATION varchar 32 128 utf8 utf8_general_ci varchar(32)
607
4.0000 information_schema SCHEMATA CATALOG_NAME varchar 512 2048 utf8 utf8_general_ci varchar(512)
608
4.0000 information_schema SCHEMATA SCHEMA_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
609
4.0000 information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
610
4.0000 information_schema SCHEMATA DEFAULT_COLLATION_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
611
4.0000 information_schema SCHEMATA SQL_PATH varchar 512 2048 utf8 utf8_general_ci varchar(512)
612
4.0000 information_schema SCHEMA_PRIVILEGES GRANTEE varchar 81 324 utf8 utf8_general_ci varchar(81)
613
4.0000 information_schema SCHEMA_PRIVILEGES TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
614
4.0000 information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
615
4.0000 information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
616
4.0000 information_schema SCHEMA_PRIVILEGES IS_GRANTABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
617
4.0000 information_schema SESSION_STATUS VARIABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
618
4.0000 information_schema SESSION_STATUS VARIABLE_VALUE varchar 16300 65200 utf8 utf8_general_ci varchar(16300)
619
4.0000 information_schema SESSION_VARIABLES VARIABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
620
4.0000 information_schema SESSION_VARIABLES VARIABLE_VALUE varchar 16300 65200 utf8 utf8_general_ci varchar(16300)
621
4.0000 information_schema STATISTICS TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
622
4.0000 information_schema STATISTICS TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
623
4.0000 information_schema STATISTICS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
624
NULL information_schema STATISTICS NON_UNIQUE bigint NULL NULL NULL NULL bigint(1)
625
4.0000 information_schema STATISTICS INDEX_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
626
4.0000 information_schema STATISTICS INDEX_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
627
NULL information_schema STATISTICS SEQ_IN_INDEX bigint NULL NULL NULL NULL bigint(2)
628
4.0000 information_schema STATISTICS COLUMN_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
629
4.0000 information_schema STATISTICS COLLATION varchar 1 4 utf8 utf8_general_ci varchar(1)
630
NULL information_schema STATISTICS CARDINALITY bigint NULL NULL NULL NULL bigint(21)
631
NULL information_schema STATISTICS SUB_PART bigint NULL NULL NULL NULL bigint(3)
632
4.0000 information_schema STATISTICS PACKED varchar 10 40 utf8 utf8_general_ci varchar(10)
633
4.0000 information_schema STATISTICS NULLABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
634
4.0000 information_schema STATISTICS INDEX_TYPE varchar 16 64 utf8 utf8_general_ci varchar(16)
635
4.0000 information_schema STATISTICS COMMENT varchar 16 64 utf8 utf8_general_ci varchar(16)
636
4.0000 information_schema STATISTICS INDEX_COMMENT varchar 1024 4096 utf8 utf8_general_ci varchar(1024)
637
4.0000 information_schema TABLES TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
638
4.0000 information_schema TABLES TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
639
4.0000 information_schema TABLES TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
640
4.0000 information_schema TABLES TABLE_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
641
4.0000 information_schema TABLES ENGINE varchar 64 256 utf8 utf8_general_ci varchar(64)
642
NULL information_schema TABLES VERSION bigint NULL NULL NULL NULL bigint(21) unsigned
643
4.0000 information_schema TABLES ROW_FORMAT varchar 10 40 utf8 utf8_general_ci varchar(10)
644
NULL information_schema TABLES TABLE_ROWS bigint NULL NULL NULL NULL bigint(21) unsigned
645
NULL information_schema TABLES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
646
NULL information_schema TABLES DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
647
NULL information_schema TABLES MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
648
NULL information_schema TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
649
NULL information_schema TABLES DATA_FREE bigint NULL NULL NULL NULL bigint(21) unsigned
650
NULL information_schema TABLES AUTO_INCREMENT bigint NULL NULL NULL NULL bigint(21) unsigned
651
NULL information_schema TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime
652
NULL information_schema TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
653
NULL information_schema TABLES CHECK_TIME datetime NULL NULL NULL NULL datetime
654
4.0000 information_schema TABLES TABLE_COLLATION varchar 64 256 utf8 utf8_general_ci varchar(64)
655
NULL information_schema TABLES CHECKSUM bigint NULL NULL NULL NULL bigint(21) unsigned
656
4.0000 information_schema TABLES CREATE_OPTIONS varchar 255 1020 utf8 utf8_general_ci varchar(255)
657
4.0000 information_schema TABLES TABLE_COMMENT varchar 2048 8192 utf8 utf8_general_ci varchar(2048)
658
4.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
659
4.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
660
4.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
661
4.0000 information_schema TABLE_CONSTRAINTS TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
662
4.0000 information_schema TABLE_CONSTRAINTS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
663
4.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
664
4.0000 information_schema TABLE_PRIVILEGES GRANTEE varchar 81 324 utf8 utf8_general_ci varchar(81)
665
4.0000 information_schema TABLE_PRIVILEGES TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
666
4.0000 information_schema TABLE_PRIVILEGES TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
667
4.0000 information_schema TABLE_PRIVILEGES TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
668
4.0000 information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
669
4.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
670
4.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
671
4.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
672
4.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
673
4.0000 information_schema TRIGGERS EVENT_MANIPULATION varchar 6 24 utf8 utf8_general_ci varchar(6)
674
4.0000 information_schema TRIGGERS EVENT_OBJECT_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
675
4.0000 information_schema TRIGGERS EVENT_OBJECT_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
676
4.0000 information_schema TRIGGERS EVENT_OBJECT_TABLE varchar 64 256 utf8 utf8_general_ci varchar(64)
677
NULL information_schema TRIGGERS ACTION_ORDER bigint NULL NULL NULL NULL bigint(4)
678
1.0000 information_schema TRIGGERS ACTION_CONDITION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
679
1.0000 information_schema TRIGGERS ACTION_STATEMENT longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
680
4.0000 information_schema TRIGGERS ACTION_ORIENTATION varchar 9 36 utf8 utf8_general_ci varchar(9)
681
4.0000 information_schema TRIGGERS ACTION_TIMING varchar 6 24 utf8 utf8_general_ci varchar(6)
682
4.0000 information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE varchar 64 256 utf8 utf8_general_ci varchar(64)
683
4.0000 information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE varchar 64 256 utf8 utf8_general_ci varchar(64)
684
4.0000 information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW varchar 3 12 utf8 utf8_general_ci varchar(3)
685
4.0000 information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW varchar 3 12 utf8 utf8_general_ci varchar(3)
686
NULL information_schema TRIGGERS CREATED datetime NULL NULL NULL NULL datetime
687
1.0000 information_schema TRIGGERS SQL_MODE longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
688
1.0000 information_schema TRIGGERS DEFINER longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
689
4.0000 information_schema TRIGGERS CHARACTER_SET_CLIENT varchar 32 128 utf8 utf8_general_ci varchar(32)
690
4.0000 information_schema TRIGGERS COLLATION_CONNECTION varchar 32 128 utf8 utf8_general_ci varchar(32)
691
4.0000 information_schema TRIGGERS DATABASE_COLLATION varchar 32 128 utf8 utf8_general_ci varchar(32)
692
4.0000 information_schema USER_PRIVILEGES GRANTEE varchar 81 324 utf8 utf8_general_ci varchar(81)
693
4.0000 information_schema USER_PRIVILEGES TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
694
4.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 256 utf8 utf8_general_ci varchar(64)
695
4.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
696
4.0000 information_schema VIEWS TABLE_CATALOG varchar 512 2048 utf8 utf8_general_ci varchar(512)
697
4.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 256 utf8 utf8_general_ci varchar(64)
698
4.0000 information_schema VIEWS TABLE_NAME varchar 64 256 utf8 utf8_general_ci varchar(64)
699
1.0000 information_schema VIEWS VIEW_DEFINITION longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
700
4.0000 information_schema VIEWS CHECK_OPTION varchar 8 32 utf8 utf8_general_ci varchar(8)
701
4.0000 information_schema VIEWS IS_UPDATABLE varchar 3 12 utf8 utf8_general_ci varchar(3)
702
4.0000 information_schema VIEWS DEFINER varchar 77 308 utf8 utf8_general_ci varchar(77)
703
4.0000 information_schema VIEWS SECURITY_TYPE varchar 7 28 utf8 utf8_general_ci varchar(7)
704
4.0000 information_schema VIEWS CHARACTER_SET_CLIENT varchar 32 128 utf8 utf8_general_ci varchar(32)
705
4.0000 information_schema VIEWS COLLATION_CONNECTION varchar 32 128 utf8 utf8_general_ci varchar(32)
added
removed
mysql-test/suite/funcs_1/r/is_columns_is.result
