← Back to branch summary

~danielpvolpato/mysql-server/parallel-mysqldump

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/is_columns_is_embedded.result

Merge from main 5.1 to 5.1-build

Show diffs side-by-side

added added

removed removed

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