1
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2
DROP DATABASE IF EXISTS test1;
5
drop table if exists tb1 ;
22
f16 tinyint unsigned zerofill,
24
f18 smallint unsigned,
25
f19 smallint zerofill,
26
f20 smallint unsigned zerofill,
28
f22 mediumint unsigned,
29
f23 mediumint zerofill,
30
f24 mediumint unsigned zerofill,
34
f28 int unsigned zerofill,
38
f32 bigint unsigned zerofill,
39
f33 decimal not null DEFAULT 9.9,
40
f34 decimal unsigned not null DEFAULT 9.9,
41
f35 decimal zerofill not null DEFAULT 9.9,
42
f36 decimal unsigned zerofill not null DEFAULT 9.9,
43
f37 decimal (0) not null DEFAULT 9.9,
44
f38 decimal (64) not null DEFAULT 9.9,
45
f39 decimal (0) unsigned not null DEFAULT 9.9,
46
f40 decimal (64) unsigned not null DEFAULT 9.9,
47
f41 decimal (0) zerofill not null DEFAULT 9.9,
48
f42 decimal (64) zerofill not null DEFAULT 9.9,
49
f43 decimal (0) unsigned zerofill not null DEFAULT 9.9,
50
f44 decimal (64) unsigned zerofill not null DEFAULT 9.9,
51
f45 decimal (0,0) not null DEFAULT 9.9,
52
f46 decimal (63,30) not null DEFAULT 9.9,
53
f47 decimal (0,0) unsigned not null DEFAULT 9.9,
54
f48 decimal (63,30) unsigned not null DEFAULT 9.9,
55
f49 decimal (0,0) zerofill not null DEFAULT 9.9,
56
f50 decimal (63,30) zerofill not null DEFAULT 9.9,
57
f51 decimal (0,0) unsigned zerofill not null DEFAULT 9.9,
58
f52 decimal (63,30) unsigned zerofill not null DEFAULT 9.9,
59
f53 numeric not null DEFAULT 99,
60
f54 numeric unsigned not null DEFAULT 99,
61
f55 numeric zerofill not null DEFAULT 99,
62
f56 numeric unsigned zerofill not null DEFAULT 99,
63
f57 numeric (0) not null DEFAULT 99,
64
f58 numeric (64) not null DEFAULT 99
67
Note 1265 Data truncated for column 'f33' at row 1
68
Note 1265 Data truncated for column 'f34' at row 1
69
Note 1265 Data truncated for column 'f35' at row 1
70
Note 1265 Data truncated for column 'f36' at row 1
71
Note 1265 Data truncated for column 'f37' at row 1
72
Note 1265 Data truncated for column 'f38' at row 1
73
Note 1265 Data truncated for column 'f39' at row 1
74
Note 1265 Data truncated for column 'f40' at row 1
75
Note 1265 Data truncated for column 'f41' at row 1
76
Note 1265 Data truncated for column 'f42' at row 1
77
Note 1265 Data truncated for column 'f43' at row 1
78
Note 1265 Data truncated for column 'f44' at row 1
79
Note 1265 Data truncated for column 'f45' at row 1
80
Note 1265 Data truncated for column 'f47' at row 1
81
Note 1265 Data truncated for column 'f49' at row 1
82
Note 1265 Data truncated for column 'f51' at row 1
83
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb1.txt' into table tb1 ;
84
drop table if exists tb2 ;
86
f59 numeric (0) unsigned,
87
f60 numeric (64) unsigned,
88
f61 numeric (0) zerofill,
89
f62 numeric (64) zerofill,
90
f63 numeric (0) unsigned zerofill,
91
f64 numeric (64) unsigned zerofill,
94
f67 numeric (0,0) unsigned,
95
f68 numeric (63,30) unsigned,
96
f69 numeric (0,0) zerofill,
97
f70 numeric (63,30) zerofill,
98
f71 numeric (0,0) unsigned zerofill,
99
f72 numeric (63,30) unsigned zerofill,
103
f76 real unsigned zerofill,
104
f77 double default 7.7,
105
f78 double unsigned default 7.7,
106
f79 double zerofill default 7.7,
107
f80 double unsigned zerofill default 8.8,
108
f81 float not null default 8.8,
109
f82 float unsigned not null default 8.8,
110
f83 float zerofill not null default 8.8,
111
f84 float unsigned zerofill not null default 8.8,
112
f85 float(0) not null default 8.8,
113
f86 float(23) not null default 8.8,
114
f87 float(0) unsigned not null default 8.8,
115
f88 float(23) unsigned not null default 8.8,
116
f89 float(0) zerofill not null default 8.8,
117
f90 float(23) zerofill not null default 8.8,
118
f91 float(0) unsigned zerofill not null default 8.8,
119
f92 float(23) unsigned zerofill not null default 8.8,
120
f93 float(24) not null default 8.8,
121
f94 float(53) not null default 8.8,
122
f95 float(24) unsigned not null default 8.8,
123
f96 float(53) unsigned not null default 8.8,
124
f97 float(24) zerofill not null default 8.8,
125
f98 float(53) zerofill not null default 8.8,
126
f99 float(24) unsigned zerofill not null default 8.8,
127
f100 float(53) unsigned zerofill not null default 8.8,
128
f101 date not null default '2000-01-01',
129
f102 time not null default 20,
130
f103 datetime not null default '2/2/2',
131
f104 timestamp not null default 20001231235959,
132
f105 year not null default 2000,
133
f106 year(3) not null default 2000,
134
f107 year(4) not null default 2000,
135
f108 enum("1enum","2enum") not null default "1enum",
136
f109 set("1set","2set") not null default "1set",
137
f110 VARBINARY(64) null,
138
f111 VARBINARY(27) null ,
139
f112 VARBINARY(64) null ,
140
f113 VARBINARY(192) null ,
141
f114 VARBINARY(192) ,
142
f115 VARBINARY(27) null ,
143
f116 VARBINARY(64) null,
144
f117 VARBINARY(192) null
146
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
147
drop table if exists tb3 ;
149
f118 char not null DEFAULT 'a',
150
f119 char binary not null DEFAULT b'101',
151
f120 char ascii not null DEFAULT b'101',
155
f124 longtext unicode,
160
f129 binary not null DEFAULT b'101',
161
f130 tinyint not null DEFAULT 99,
162
f131 tinyint unsigned not null DEFAULT 99,
163
f132 tinyint zerofill not null DEFAULT 99,
164
f133 tinyint unsigned zerofill not null DEFAULT 99,
165
f134 smallint not null DEFAULT 999,
166
f135 smallint unsigned not null DEFAULT 999,
167
f136 smallint zerofill not null DEFAULT 999,
168
f137 smallint unsigned zerofill not null DEFAULT 999,
169
f138 mediumint not null DEFAULT 9999,
170
f139 mediumint unsigned not null DEFAULT 9999,
171
f140 mediumint zerofill not null DEFAULT 9999,
172
f141 mediumint unsigned zerofill not null DEFAULT 9999,
173
f142 int not null DEFAULT 99999,
174
f143 int unsigned not null DEFAULT 99999,
175
f144 int zerofill not null DEFAULT 99999,
176
f145 int unsigned zerofill not null DEFAULT 99999,
177
f146 bigint not null DEFAULT 999999,
178
f147 bigint unsigned not null DEFAULT 999999,
179
f148 bigint zerofill not null DEFAULT 999999,
180
f149 bigint unsigned zerofill not null DEFAULT 999999,
181
f150 decimal not null DEFAULT 999.999,
182
f151 decimal unsigned not null DEFAULT 999.17,
183
f152 decimal zerofill not null DEFAULT 999.999,
184
f153 decimal unsigned zerofill,
187
f156 decimal (0) unsigned,
188
f157 decimal (64) unsigned,
189
f158 decimal (0) zerofill,
190
f159 decimal (64) zerofill,
191
f160 decimal (0) unsigned zerofill,
192
f161 decimal (64) unsigned zerofill,
194
f163 decimal (63,30),
195
f164 decimal (0,0) unsigned,
196
f165 decimal (63,30) unsigned,
197
f166 decimal (0,0) zerofill,
198
f167 decimal (63,30) zerofill,
199
f168 decimal (0,0) unsigned zerofill,
200
f169 decimal (63,30) unsigned zerofill,
202
f171 numeric unsigned,
203
f172 numeric zerofill,
204
f173 numeric unsigned zerofill,
209
Note 1265 Data truncated for column 'f150' at row 1
210
Note 1265 Data truncated for column 'f151' at row 1
211
Note 1265 Data truncated for column 'f152' at row 1
212
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb3.txt' into table tb3 ;
213
drop table if exists tb4 ;
215
f176 numeric (0) unsigned not null DEFAULT 9,
216
f177 numeric (64) unsigned not null DEFAULT 9,
217
f178 numeric (0) zerofill not null DEFAULT 9,
218
f179 numeric (64) zerofill not null DEFAULT 9,
219
f180 numeric (0) unsigned zerofill not null DEFAULT 9,
220
f181 numeric (64) unsigned zerofill not null DEFAULT 9,
221
f182 numeric (0,0) not null DEFAULT 9,
222
f183 numeric (63,30) not null DEFAULT 9,
223
f184 numeric (0,0) unsigned not null DEFAULT 9,
224
f185 numeric (63,30) unsigned not null DEFAULT 9,
225
f186 numeric (0,0) zerofill not null DEFAULT 9,
226
f187 numeric (63,30) zerofill not null DEFAULT 9,
227
f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
228
f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
229
f190 real not null DEFAULT 88.8,
230
f191 real unsigned not null DEFAULT 88.8,
231
f192 real zerofill not null DEFAULT 88.8,
232
f193 real unsigned zerofill not null DEFAULT 88.8,
233
f194 double not null DEFAULT 55.5,
234
f195 double unsigned not null DEFAULT 55.5,
235
f196 double zerofill not null DEFAULT 55.5,
236
f197 double unsigned zerofill not null DEFAULT 55.5,
240
f201 float unsigned zerofill,
243
f204 float(0) unsigned,
244
f205 float(23) unsigned,
245
f206 float(0) zerofill,
246
f207 float(23) zerofill,
247
f208 float(0) unsigned zerofill,
248
f209 float(23) unsigned zerofill,
251
f212 float(24) unsigned,
252
f213 float(53) unsigned,
253
f214 float(24) zerofill,
254
f215 float(53) zerofill,
255
f216 float(24) unsigned zerofill,
256
f217 float(53) unsigned zerofill,
264
f225 enum("1enum","2enum"),
265
f226 set("1set","2set"),
274
f235 char(255) unicode,
276
f237 char(255) binary,
277
f238 varchar(0) binary,
278
f239 varbinary(1000),
279
f240 varchar(120) unicode,
280
f241 char(100) unicode,
283
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb4.txt' into table tb4 ;
285
drop table if exists tb2 ;
287
f59 numeric (0) unsigned,
288
f60 numeric (64) unsigned,
289
f61 numeric (0) zerofill,
290
f62 numeric (64) zerofill,
291
f63 numeric (0) unsigned zerofill,
292
f64 numeric (64) unsigned zerofill,
295
f67 numeric (0,0) unsigned,
296
f68 numeric (63,30) unsigned,
297
f69 numeric (0,0) zerofill,
298
f70 numeric (63,30) zerofill,
299
f71 numeric (0,0) unsigned zerofill,
300
f72 numeric (63,30) unsigned zerofill,
304
f76 real unsigned zerofill,
305
f77 double default 7.7,
306
f78 double unsigned default 7.7,
307
f79 double zerofill default 7.7,
308
f80 double unsigned zerofill default 8.8,
309
f81 float not null default 8.8,
310
f82 float unsigned not null default 8.8,
311
f83 float zerofill not null default 8.8,
312
f84 float unsigned zerofill not null default 8.8,
313
f85 float(0) not null default 8.8,
314
f86 float(23) not null default 8.8,
315
f87 float(0) unsigned not null default 8.8,
316
f88 float(23) unsigned not null default 8.8,
317
f89 float(0) zerofill not null default 8.8,
318
f90 float(23) zerofill not null default 8.8,
319
f91 float(0) unsigned zerofill not null default 8.8,
320
f92 float(23) unsigned zerofill not null default 8.8,
321
f93 float(24) not null default 8.8,
322
f94 float(53) not null default 8.8,
323
f95 float(24) unsigned not null default 8.8,
324
f96 float(53) unsigned not null default 8.8,
325
f97 float(24) zerofill not null default 8.8,
326
f98 float(53) zerofill not null default 8.8,
327
f99 float(24) unsigned zerofill not null default 8.8,
328
f100 float(53) unsigned zerofill not null default 8.8,
329
f101 date not null default '2000-01-01',
330
f102 time not null default 20,
331
f103 datetime not null default '2/2/2',
332
f104 timestamp not null default 20001231235959,
333
f105 year not null default 2000,
334
f106 year(3) not null default 2000,
335
f107 year(4) not null default 2000,
336
f108 enum("1enum","2enum") not null default "1enum",
337
f109 set("1set","2set") not null default "1set",
338
f110 VARBINARY(64) null,
339
f111 VARBINARY(27) null ,
340
f112 VARBINARY(64) null ,
341
f113 VARBINARY(192) null ,
342
f114 VARBINARY(192) ,
343
f115 VARBINARY(27) null ,
344
f116 VARBINARY(64) null,
345
f117 VARBINARY(192) null
347
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
350
DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
351
CREATE TABLE t1 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
352
CREATE TABLE t2 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
353
CREATE TABLE t4 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
354
CREATE TABLE t10 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
355
CREATE TABLE t11 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
356
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t1;
357
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t2;
358
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t4;
359
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t10;
360
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t11;
361
drop TABLE if exists t3;
362
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = MyISAM;
363
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t3.txt' INTO TABLE t3;
364
drop database if exists test4;
365
CREATE database test4;
367
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
368
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t6;
370
drop TABLE if exists t7, t8;
371
CREATE TABLE t7 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = MyISAM;
372
CREATE TABLE t8 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = MyISAM;
373
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t7;
375
Warning 1265 Data truncated for column 'f3' at row 1
376
Warning 1265 Data truncated for column 'f3' at row 2
377
Warning 1265 Data truncated for column 'f3' at row 3
378
Warning 1265 Data truncated for column 'f3' at row 4
379
Warning 1265 Data truncated for column 'f3' at row 5
380
Warning 1265 Data truncated for column 'f3' at row 6
381
Warning 1265 Data truncated for column 'f3' at row 7
382
Warning 1265 Data truncated for column 'f3' at row 8
383
Warning 1265 Data truncated for column 'f3' at row 9
384
Warning 1265 Data truncated for column 'f3' at row 10
385
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t8;
387
Warning 1265 Data truncated for column 'f3' at row 1
388
Warning 1265 Data truncated for column 'f3' at row 2
389
Warning 1265 Data truncated for column 'f3' at row 3
390
Warning 1265 Data truncated for column 'f3' at row 4
391
Warning 1265 Data truncated for column 'f3' at row 5
392
Warning 1265 Data truncated for column 'f3' at row 6
393
Warning 1265 Data truncated for column 'f3' at row 7
394
Warning 1265 Data truncated for column 'f3' at row 8
395
Warning 1265 Data truncated for column 'f3' at row 9
396
Warning 1265 Data truncated for column 'f3' at row 10
397
drop TABLE if exists t9;
398
CREATE TABLE t9 (f1 int, f2 char(25), f3 int) ENGINE = MyISAM;
399
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t9.txt' INTO TABLE t9;
400
SELECT * FROM information_schema.columns
401
WHERE table_schema LIKE 'test%'
402
ORDER BY table_schema, table_name, column_name;
403
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT STORAGE FORMAT
404
NULL test t1 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
405
NULL test t1 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
406
NULL test t1 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
407
NULL test t1 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
408
NULL test t1 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
409
NULL test t1 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
410
NULL test t10 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
411
NULL test t10 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
412
NULL test t10 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
413
NULL test t10 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
414
NULL test t10 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
415
NULL test t10 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
416
NULL test t11 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
417
NULL test t11 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
418
NULL test t11 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
419
NULL test t11 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
420
NULL test t11 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
421
NULL test t11 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
422
NULL test t2 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
423
NULL test t2 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
424
NULL test t2 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
425
NULL test t2 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
426
NULL test t2 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
427
NULL test t2 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
428
NULL test t3 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
429
NULL test t3 f2 2 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
430
NULL test t3 f3 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
431
NULL test t4 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
432
NULL test t4 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
433
NULL test t4 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
434
NULL test t4 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
435
NULL test t4 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
436
NULL test t4 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
437
NULL test t7 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
438
NULL test t7 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
439
NULL test t7 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
440
NULL test t7 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
441
NULL test t8 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
442
NULL test t8 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
443
NULL test t8 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
444
NULL test t8 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
445
NULL test t9 f1 1 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
446
NULL test t9 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
447
NULL test t9 f3 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
448
NULL test tb1 f1 1 NULL YES char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references Default Default
449
NULL test tb1 f10 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL mediumblob select,insert,update,references Default Default
450
NULL test tb1 f11 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob select,insert,update,references Default Default
451
NULL test tb1 f12 12 NULL YES binary 1 1 NULL NULL NULL NULL binary(1) select,insert,update,references Default Default
452
NULL test tb1 f13 13 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(4) select,insert,update,references Default Default
453
NULL test tb1 f14 14 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned select,insert,update,references Default Default
454
NULL test tb1 f15 15 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references Default Default
455
NULL test tb1 f16 16 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references Default Default
456
NULL test tb1 f17 17 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(6) select,insert,update,references Default Default
457
NULL test tb1 f18 18 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned select,insert,update,references Default Default
458
NULL test tb1 f19 19 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references Default Default
459
NULL test tb1 f2 2 NULL YES char 1 1 NULL NULL latin1 latin1_bin char(1) select,insert,update,references Default Default
460
NULL test tb1 f20 20 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references Default Default
461
NULL test tb1 f21 21 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(9) select,insert,update,references Default Default
462
NULL test tb1 f22 22 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned select,insert,update,references Default Default
463
NULL test tb1 f23 23 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references Default Default
464
NULL test tb1 f24 24 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references Default Default
465
NULL test tb1 f25 25 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
466
NULL test tb1 f26 26 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references Default Default
467
NULL test tb1 f27 27 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references Default Default
468
NULL test tb1 f28 28 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references Default Default
469
NULL test tb1 f29 29 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references Default Default
470
NULL test tb1 f3 3 NULL YES char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references Default Default
471
NULL test tb1 f30 30 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned select,insert,update,references Default Default
472
NULL test tb1 f31 31 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references Default Default
473
NULL test tb1 f32 32 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references Default Default
474
NULL test tb1 f33 33 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
475
NULL test tb1 f34 34 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
476
NULL test tb1 f35 35 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
477
NULL test tb1 f36 36 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
478
NULL test tb1 f37 37 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
479
NULL test tb1 f38 38 10 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references Default Default
480
NULL test tb1 f39 39 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
481
NULL test tb1 f4 4 NULL YES tinytext 127 255 NULL NULL ucs2 ucs2_general_ci tinytext select,insert,update,references Default Default
482
NULL test tb1 f40 40 10 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references Default Default
483
NULL test tb1 f41 41 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
484
NULL test tb1 f42 42 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
485
NULL test tb1 f43 43 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
486
NULL test tb1 f44 44 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
487
NULL test tb1 f45 45 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
488
NULL test tb1 f46 46 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references Default Default
489
NULL test tb1 f47 47 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
490
NULL test tb1 f48 48 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references Default Default
491
NULL test tb1 f49 49 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
492
NULL test tb1 f5 5 NULL YES text 65535 65535 NULL NULL latin1 latin1_swedish_ci text select,insert,update,references Default Default
493
NULL test tb1 f50 50 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
494
NULL test tb1 f51 51 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
495
NULL test tb1 f52 52 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
496
NULL test tb1 f53 53 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
497
NULL test tb1 f54 54 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
498
NULL test tb1 f55 55 0000000099 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
499
NULL test tb1 f56 56 0000000099 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
500
NULL test tb1 f57 57 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
501
NULL test tb1 f58 58 99 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references Default Default
502
NULL test tb1 f6 6 NULL YES mediumtext 16777215 16777215 NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references Default Default
503
NULL test tb1 f7 7 NULL YES longtext 4294967295 4294967295 NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references Default Default
504
NULL test tb1 f8 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL tinyblob select,insert,update,references Default Default
505
NULL test tb1 f9 9 NULL YES blob 65535 65535 NULL NULL NULL NULL blob select,insert,update,references Default Default
506
NULL test tb2 f100 42 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
507
NULL test tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
508
NULL test tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL NULL NULL time select,insert,update,references Default Default
509
NULL test tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references Default Default
510
NULL test tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL NULL NULL timestamp select,insert,update,references Default Default
511
NULL test tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
512
NULL test tb2 f106 48 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
513
NULL test tb2 f107 49 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
514
NULL test tb2 f108 50 1enum NO enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references Default Default
515
NULL test tb2 f109 51 1set NO set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references Default Default
516
NULL test tb2 f110 52 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
517
NULL test tb2 f111 53 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
518
NULL test tb2 f112 54 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
519
NULL test tb2 f113 55 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
520
NULL test tb2 f114 56 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
521
NULL test tb2 f115 57 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
522
NULL test tb2 f116 58 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
523
NULL test tb2 f117 59 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
524
NULL test tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
525
NULL test tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references Default Default
526
NULL test tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
527
NULL test tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
528
NULL test tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
529
NULL test tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
530
NULL test tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
531
NULL test tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references Default Default
532
NULL test tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
533
NULL test tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references Default Default
534
NULL test tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
535
NULL test tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
536
NULL test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
537
NULL test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
538
NULL test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
539
NULL test tb2 f74 16 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
540
NULL test tb2 f75 17 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
541
NULL test tb2 f76 18 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
542
NULL test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
543
NULL test tb2 f78 20 7.7 YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
544
NULL test tb2 f79 21 00000000000000000007.7 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
545
NULL test tb2 f80 22 00000000000000000008.8 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
546
NULL test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
547
NULL test tb2 f82 24 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
548
NULL test tb2 f83 25 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
549
NULL test tb2 f84 26 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
550
NULL test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
551
NULL test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
552
NULL test tb2 f87 29 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
553
NULL test tb2 f88 30 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
554
NULL test tb2 f89 31 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
555
NULL test tb2 f90 32 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
556
NULL test tb2 f91 33 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
557
NULL test tb2 f92 34 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
558
NULL test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
559
NULL test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
560
NULL test tb2 f95 37 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
561
NULL test tb2 f96 38 8.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
562
NULL test tb2 f97 39 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
563
NULL test tb2 f98 40 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
564
NULL test tb2 f99 41 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
565
NULL test tb3 f118 1 a NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references Default Default
566
NULL test tb3 f119 2 NO char 1 1 NULL NULL latin1 latin1_bin char(1) select,insert,update,references Default Default
567
NULL test tb3 f120 3 NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references Default Default
568
NULL test tb3 f121 4 NULL YES tinytext 255 255 NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references Default Default
569
NULL test tb3 f122 5 NULL YES text 65535 65535 NULL NULL latin1 latin1_swedish_ci text select,insert,update,references Default Default
570
NULL test tb3 f123 6 NULL YES mediumtext 16777215 16777215 NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references Default Default
571
NULL test tb3 f124 7 NULL YES longtext 2147483647 4294967295 NULL NULL ucs2 ucs2_general_ci longtext select,insert,update,references Default Default
572
NULL test tb3 f125 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL tinyblob select,insert,update,references Default Default
573
NULL test tb3 f126 9 NULL YES blob 65535 65535 NULL NULL NULL NULL blob select,insert,update,references Default Default
574
NULL test tb3 f127 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL mediumblob select,insert,update,references Default Default
575
NULL test tb3 f128 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob select,insert,update,references Default Default
576
NULL test tb3 f129 12 NO binary 1 1 NULL NULL NULL NULL binary(1) select,insert,update,references Default Default
577
NULL test tb3 f130 13 99 NO tinyint NULL NULL 3 0 NULL NULL tinyint(4) select,insert,update,references Default Default
578
NULL test tb3 f131 14 99 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned select,insert,update,references Default Default
579
NULL test tb3 f132 15 099 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references Default Default
580
NULL test tb3 f133 16 099 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references Default Default
581
NULL test tb3 f134 17 999 NO smallint NULL NULL 5 0 NULL NULL smallint(6) select,insert,update,references Default Default
582
NULL test tb3 f135 18 999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned select,insert,update,references Default Default
583
NULL test tb3 f136 19 00999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references Default Default
584
NULL test tb3 f137 20 00999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references Default Default
585
NULL test tb3 f138 21 9999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(9) select,insert,update,references Default Default
586
NULL test tb3 f139 22 9999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned select,insert,update,references Default Default
587
NULL test tb3 f140 23 00009999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references Default Default
588
NULL test tb3 f141 24 00009999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references Default Default
589
NULL test tb3 f142 25 99999 NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
590
NULL test tb3 f143 26 99999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references Default Default
591
NULL test tb3 f144 27 0000099999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references Default Default
592
NULL test tb3 f145 28 0000099999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references Default Default
593
NULL test tb3 f146 29 999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references Default Default
594
NULL test tb3 f147 30 999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned select,insert,update,references Default Default
595
NULL test tb3 f148 31 00000000000000999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references Default Default
596
NULL test tb3 f149 32 00000000000000999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references Default Default
597
NULL test tb3 f150 33 1000 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
598
NULL test tb3 f151 34 999 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
599
NULL test tb3 f152 35 0000001000 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
600
NULL test tb3 f153 36 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
601
NULL test tb3 f154 37 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
602
NULL test tb3 f155 38 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references Default Default
603
NULL test tb3 f156 39 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
604
NULL test tb3 f157 40 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references Default Default
605
NULL test tb3 f158 41 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
606
NULL test tb3 f159 42 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
607
NULL test tb3 f160 43 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
608
NULL test tb3 f161 44 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
609
NULL test tb3 f162 45 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
610
NULL test tb3 f163 46 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references Default Default
611
NULL test tb3 f164 47 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
612
NULL test tb3 f165 48 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references Default Default
613
NULL test tb3 f166 49 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
614
NULL test tb3 f167 50 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
615
NULL test tb3 f168 51 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
616
NULL test tb3 f169 52 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
617
NULL test tb3 f170 53 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
618
NULL test tb3 f171 54 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
619
NULL test tb3 f172 55 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
620
NULL test tb3 f173 56 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
621
NULL test tb3 f174 57 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
622
NULL test tb3 f175 58 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references Default Default
623
NULL test tb4 f176 1 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
624
NULL test tb4 f177 2 9 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references Default Default
625
NULL test tb4 f178 3 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
626
NULL test tb4 f179 4 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
627
NULL test tb4 f180 5 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
628
NULL test tb4 f181 6 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
629
NULL test tb4 f182 7 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
630
NULL test tb4 f183 8 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references Default Default
631
NULL test tb4 f184 9 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
632
NULL test tb4 f185 10 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references Default Default
633
NULL test tb4 f186 11 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
634
NULL test tb4 f187 12 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
635
NULL test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
636
NULL test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
637
NULL test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
638
NULL test tb4 f191 16 88.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
639
NULL test tb4 f192 17 00000000000000000088.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
640
NULL test tb4 f193 18 00000000000000000088.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
641
NULL test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
642
NULL test tb4 f195 20 55.5 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
643
NULL test tb4 f196 21 00000000000000000055.5 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
644
NULL test tb4 f197 22 00000000000000000055.5 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
645
NULL test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
646
NULL test tb4 f199 24 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
647
NULL test tb4 f200 25 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
648
NULL test tb4 f201 26 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
649
NULL test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
650
NULL test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
651
NULL test tb4 f204 29 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
652
NULL test tb4 f205 30 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
653
NULL test tb4 f206 31 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
654
NULL test tb4 f207 32 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
655
NULL test tb4 f208 33 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
656
NULL test tb4 f209 34 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
657
NULL test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
658
NULL test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
659
NULL test tb4 f212 37 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
660
NULL test tb4 f213 38 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
661
NULL test tb4 f214 39 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
662
NULL test tb4 f215 40 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
663
NULL test tb4 f216 41 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
664
NULL test tb4 f217 42 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
665
NULL test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
666
NULL test tb4 f219 44 NULL YES time NULL NULL NULL NULL NULL NULL time select,insert,update,references Default Default
667
NULL test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references Default Default
668
NULL test tb4 f221 46 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP select,insert,update,references Default Default
669
NULL test tb4 f222 47 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
670
NULL test tb4 f223 48 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
671
NULL test tb4 f224 49 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
672
NULL test tb4 f225 50 NULL YES enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references Default Default
673
NULL test tb4 f226 51 NULL YES set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references Default Default
674
NULL test tb4 f227 52 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
675
NULL test tb4 f228 53 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
676
NULL test tb4 f229 54 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
677
NULL test tb4 f230 55 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
678
NULL test tb4 f231 56 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
679
NULL test tb4 f232 57 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
680
NULL test tb4 f233 58 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
681
NULL test tb4 f234 59 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
682
NULL test tb4 f235 60 NULL YES char 255 510 NULL NULL ucs2 ucs2_general_ci char(255) select,insert,update,references Default Default
683
NULL test tb4 f236 61 NULL YES char 60 60 NULL NULL latin1 latin1_swedish_ci char(60) select,insert,update,references Default Default
684
NULL test tb4 f237 62 NULL YES char 255 255 NULL NULL latin1 latin1_bin char(255) select,insert,update,references Default Default
685
NULL test tb4 f238 63 NULL YES varchar 0 0 NULL NULL latin1 latin1_bin varchar(0) select,insert,update,references Default Default
686
NULL test tb4 f239 64 NULL YES varbinary 1000 1000 NULL NULL NULL NULL varbinary(1000) select,insert,update,references Default Default
687
NULL test tb4 f240 65 NULL YES varchar 120 240 NULL NULL ucs2 ucs2_general_ci varchar(120) select,insert,update,references Default Default
688
NULL test tb4 f241 66 NULL YES char 100 200 NULL NULL ucs2 ucs2_general_ci char(100) select,insert,update,references Default Default
689
NULL test tb4 f242 67 NULL YES bit NULL NULL 30 NULL NULL NULL bit(30) select,insert,update,references Default Default
690
NULL test1 tb2 f100 42 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
691
NULL test1 tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
692
NULL test1 tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL NULL NULL time select,insert,update,references Default Default
693
NULL test1 tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references Default Default
694
NULL test1 tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL NULL NULL timestamp select,insert,update,references Default Default
695
NULL test1 tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
696
NULL test1 tb2 f106 48 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
697
NULL test1 tb2 f107 49 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references Default Default
698
NULL test1 tb2 f108 50 1enum NO enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references Default Default
699
NULL test1 tb2 f109 51 1set NO set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references Default Default
700
NULL test1 tb2 f110 52 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
701
NULL test1 tb2 f111 53 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
702
NULL test1 tb2 f112 54 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
703
NULL test1 tb2 f113 55 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
704
NULL test1 tb2 f114 56 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
705
NULL test1 tb2 f115 57 NULL YES varbinary 27 27 NULL NULL NULL NULL varbinary(27) select,insert,update,references Default Default
706
NULL test1 tb2 f116 58 NULL YES varbinary 64 64 NULL NULL NULL NULL varbinary(64) select,insert,update,references Default Default
707
NULL test1 tb2 f117 59 NULL YES varbinary 192 192 NULL NULL NULL NULL varbinary(192) select,insert,update,references Default Default
708
NULL test1 tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
709
NULL test1 tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references Default Default
710
NULL test1 tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
711
NULL test1 tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
712
NULL test1 tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
713
NULL test1 tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references Default Default
714
NULL test1 tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default
715
NULL test1 tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references Default Default
716
NULL test1 tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default
717
NULL test1 tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references Default Default
718
NULL test1 tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
719
NULL test1 tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
720
NULL test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default
721
NULL test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references Default Default
722
NULL test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
723
NULL test1 tb2 f74 16 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
724
NULL test1 tb2 f75 17 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
725
NULL test1 tb2 f76 18 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
726
NULL test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
727
NULL test1 tb2 f78 20 7.7 YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
728
NULL test1 tb2 f79 21 00000000000000000007.7 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
729
NULL test1 tb2 f80 22 00000000000000000008.8 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
730
NULL test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
731
NULL test1 tb2 f82 24 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
732
NULL test1 tb2 f83 25 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
733
NULL test1 tb2 f84 26 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
734
NULL test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
735
NULL test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
736
NULL test1 tb2 f87 29 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
737
NULL test1 tb2 f88 30 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
738
NULL test1 tb2 f89 31 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
739
NULL test1 tb2 f90 32 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
740
NULL test1 tb2 f91 33 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
741
NULL test1 tb2 f92 34 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
742
NULL test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references Default Default
743
NULL test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references Default Default
744
NULL test1 tb2 f95 37 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references Default Default
745
NULL test1 tb2 f96 38 8.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references Default Default
746
NULL test1 tb2 f97 39 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
747
NULL test1 tb2 f98 40 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references Default Default
748
NULL test1 tb2 f99 41 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references Default Default
749
NULL test4 t6 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references Default Default
750
NULL test4 t6 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
751
NULL test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references Default Default
752
NULL test4 t6 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
753
NULL test4 t6 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references Default Default
754
NULL test4 t6 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references Default Default
755
##########################################################################
756
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
757
##########################################################################
759
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
763
FROM information_schema.columns
764
WHERE table_schema LIKE 'test%'
765
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
766
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
767
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
768
1.0000 binary NULL NULL
769
1.0000 blob NULL NULL
770
1.0000 longblob NULL NULL
771
1.0000 mediumblob NULL NULL
772
1.0000 tinyblob NULL NULL
773
1.0000 varbinary NULL NULL
774
1.0000 char latin1 latin1_bin
775
1.0000 char latin1 latin1_swedish_ci
776
1.0000 enum latin1 latin1_swedish_ci
777
1.0000 longtext latin1 latin1_swedish_ci
778
1.0000 mediumtext latin1 latin1_swedish_ci
779
1.0000 set latin1 latin1_swedish_ci
780
1.0000 text latin1 latin1_swedish_ci
781
1.0000 tinytext latin1 latin1_swedish_ci
783
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
787
FROM information_schema.columns
788
WHERE table_schema LIKE 'test%'
789
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1
790
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
791
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
792
2.0000 char ucs2 ucs2_general_ci
793
2.0000 longtext ucs2 ucs2_general_ci
794
2.0000 varchar ucs2 ucs2_general_ci
795
2.0079 tinytext ucs2 ucs2_general_ci
797
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
801
FROM information_schema.columns
802
WHERE table_schema LIKE 'test%'
803
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL
804
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
805
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
806
NULL bigint NULL NULL
809
NULL datetime NULL NULL
810
NULL decimal NULL NULL
811
NULL double NULL NULL
812
NULL double unsigned NULL NULL
813
NULL double unsigned zerofill NULL NULL
815
NULL float unsigned NULL NULL
816
NULL float unsigned zerofill NULL NULL
818
NULL mediumint NULL NULL
819
NULL smallint NULL NULL
821
NULL timestamp NULL NULL
822
NULL tinyint NULL NULL
824
NULL varchar latin1 latin1_bin
825
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values
826
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL
827
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
832
CHARACTER_MAXIMUM_LENGTH,
833
CHARACTER_OCTET_LENGTH,
837
FROM information_schema.columns
838
WHERE table_schema LIKE 'test%'
839
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
840
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
841
1.0000 test t1 f1 char 20 20 latin1 latin1_swedish_ci char(20)
842
1.0000 test t1 f2 char 25 25 latin1 latin1_swedish_ci char(25)
843
NULL test t1 f3 date NULL NULL NULL NULL date
844
NULL test t1 f4 int NULL NULL NULL NULL int(11)
845
1.0000 test t1 f5 char 25 25 latin1 latin1_swedish_ci char(25)
846
NULL test t1 f6 int NULL NULL NULL NULL int(11)
847
1.0000 test t10 f1 char 20 20 latin1 latin1_swedish_ci char(20)
848
1.0000 test t10 f2 char 25 25 latin1 latin1_swedish_ci char(25)
849
NULL test t10 f3 date NULL NULL NULL NULL date
850
NULL test t10 f4 int NULL NULL NULL NULL int(11)
851
1.0000 test t10 f5 char 25 25 latin1 latin1_swedish_ci char(25)
852
NULL test t10 f6 int NULL NULL NULL NULL int(11)
853
1.0000 test t11 f1 char 20 20 latin1 latin1_swedish_ci char(20)
854
1.0000 test t11 f2 char 25 25 latin1 latin1_swedish_ci char(25)
855
NULL test t11 f3 date NULL NULL NULL NULL date
856
NULL test t11 f4 int NULL NULL NULL NULL int(11)
857
1.0000 test t11 f5 char 25 25 latin1 latin1_swedish_ci char(25)
858
NULL test t11 f6 int NULL NULL NULL NULL int(11)
859
1.0000 test t2 f1 char 20 20 latin1 latin1_swedish_ci char(20)
860
1.0000 test t2 f2 char 25 25 latin1 latin1_swedish_ci char(25)
861
NULL test t2 f3 date NULL NULL NULL NULL date
862
NULL test t2 f4 int NULL NULL NULL NULL int(11)
863
1.0000 test t2 f5 char 25 25 latin1 latin1_swedish_ci char(25)
864
NULL test t2 f6 int NULL NULL NULL NULL int(11)
865
1.0000 test t3 f1 char 20 20 latin1 latin1_swedish_ci char(20)
866
1.0000 test t3 f2 char 20 20 latin1 latin1_swedish_ci char(20)
867
NULL test t3 f3 int NULL NULL NULL NULL int(11)
868
1.0000 test t4 f1 char 20 20 latin1 latin1_swedish_ci char(20)
869
1.0000 test t4 f2 char 25 25 latin1 latin1_swedish_ci char(25)
870
NULL test t4 f3 date NULL NULL NULL NULL date
871
NULL test t4 f4 int NULL NULL NULL NULL int(11)
872
1.0000 test t4 f5 char 25 25 latin1 latin1_swedish_ci char(25)
873
NULL test t4 f6 int NULL NULL NULL NULL int(11)
874
1.0000 test t7 f1 char 20 20 latin1 latin1_swedish_ci char(20)
875
1.0000 test t7 f2 char 25 25 latin1 latin1_swedish_ci char(25)
876
NULL test t7 f3 date NULL NULL NULL NULL date
877
NULL test t7 f4 int NULL NULL NULL NULL int(11)
878
1.0000 test t8 f1 char 20 20 latin1 latin1_swedish_ci char(20)
879
1.0000 test t8 f2 char 25 25 latin1 latin1_swedish_ci char(25)
880
NULL test t8 f3 date NULL NULL NULL NULL date
881
NULL test t8 f4 int NULL NULL NULL NULL int(11)
882
NULL test t9 f1 int NULL NULL NULL NULL int(11)
883
1.0000 test t9 f2 char 25 25 latin1 latin1_swedish_ci char(25)
884
NULL test t9 f3 int NULL NULL NULL NULL int(11)
885
1.0000 test tb1 f1 char 1 1 latin1 latin1_swedish_ci char(1)
886
1.0000 test tb1 f2 char 1 1 latin1 latin1_bin char(1)
887
1.0000 test tb1 f3 char 1 1 latin1 latin1_swedish_ci char(1)
888
2.0079 test tb1 f4 tinytext 127 255 ucs2 ucs2_general_ci tinytext
889
1.0000 test tb1 f5 text 65535 65535 latin1 latin1_swedish_ci text
890
1.0000 test tb1 f6 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
891
1.0000 test tb1 f7 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext
892
1.0000 test tb1 f8 tinyblob 255 255 NULL NULL tinyblob
893
1.0000 test tb1 f9 blob 65535 65535 NULL NULL blob
894
1.0000 test tb1 f10 mediumblob 16777215 16777215 NULL NULL mediumblob
895
1.0000 test tb1 f11 longblob 4294967295 4294967295 NULL NULL longblob
896
1.0000 test tb1 f12 binary 1 1 NULL NULL binary(1)
897
NULL test tb1 f13 tinyint NULL NULL NULL NULL tinyint(4)
898
NULL test tb1 f14 tinyint NULL NULL NULL NULL tinyint(3) unsigned
899
NULL test tb1 f15 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
900
NULL test tb1 f16 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
901
NULL test tb1 f17 smallint NULL NULL NULL NULL smallint(6)
902
NULL test tb1 f18 smallint NULL NULL NULL NULL smallint(5) unsigned
903
NULL test tb1 f19 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
904
NULL test tb1 f20 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
905
NULL test tb1 f21 mediumint NULL NULL NULL NULL mediumint(9)
906
NULL test tb1 f22 mediumint NULL NULL NULL NULL mediumint(8) unsigned
907
NULL test tb1 f23 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
908
NULL test tb1 f24 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
909
NULL test tb1 f25 int NULL NULL NULL NULL int(11)
910
NULL test tb1 f26 int NULL NULL NULL NULL int(10) unsigned
911
NULL test tb1 f27 int NULL NULL NULL NULL int(10) unsigned zerofill
912
NULL test tb1 f28 int NULL NULL NULL NULL int(10) unsigned zerofill
913
NULL test tb1 f29 bigint NULL NULL NULL NULL bigint(20)
914
NULL test tb1 f30 bigint NULL NULL NULL NULL bigint(20) unsigned
915
NULL test tb1 f31 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
916
NULL test tb1 f32 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
917
NULL test tb1 f33 decimal NULL NULL NULL NULL decimal(10,0)
918
NULL test tb1 f34 decimal NULL NULL NULL NULL decimal(10,0) unsigned
919
NULL test tb1 f35 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
920
NULL test tb1 f36 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
921
NULL test tb1 f37 decimal NULL NULL NULL NULL decimal(10,0)
922
NULL test tb1 f38 decimal NULL NULL NULL NULL decimal(64,0)
923
NULL test tb1 f39 decimal NULL NULL NULL NULL decimal(10,0) unsigned
924
NULL test tb1 f40 decimal NULL NULL NULL NULL decimal(64,0) unsigned
925
NULL test tb1 f41 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
926
NULL test tb1 f42 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
927
NULL test tb1 f43 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
928
NULL test tb1 f44 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
929
NULL test tb1 f45 decimal NULL NULL NULL NULL decimal(10,0)
930
NULL test tb1 f46 decimal NULL NULL NULL NULL decimal(63,30)
931
NULL test tb1 f47 decimal NULL NULL NULL NULL decimal(10,0) unsigned
932
NULL test tb1 f48 decimal NULL NULL NULL NULL decimal(63,30) unsigned
933
NULL test tb1 f49 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
934
NULL test tb1 f50 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
935
NULL test tb1 f51 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
936
NULL test tb1 f52 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
937
NULL test tb1 f53 decimal NULL NULL NULL NULL decimal(10,0)
938
NULL test tb1 f54 decimal NULL NULL NULL NULL decimal(10,0) unsigned
939
NULL test tb1 f55 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
940
NULL test tb1 f56 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
941
NULL test tb1 f57 decimal NULL NULL NULL NULL decimal(10,0)
942
NULL test tb1 f58 decimal NULL NULL NULL NULL decimal(64,0)
943
NULL test tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
944
NULL test tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
945
NULL test tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
946
NULL test tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
947
NULL test tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
948
NULL test tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
949
NULL test tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
950
NULL test tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
951
NULL test tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
952
NULL test tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
953
NULL test tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
954
NULL test tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
955
NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
956
NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
957
NULL test tb2 f73 double NULL NULL NULL NULL double
958
NULL test tb2 f74 double unsigned NULL NULL NULL NULL double unsigned
959
NULL test tb2 f75 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
960
NULL test tb2 f76 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
961
NULL test tb2 f77 double NULL NULL NULL NULL double
962
NULL test tb2 f78 double unsigned NULL NULL NULL NULL double unsigned
963
NULL test tb2 f79 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
964
NULL test tb2 f80 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
965
NULL test tb2 f81 float NULL NULL NULL NULL float
966
NULL test tb2 f82 float unsigned NULL NULL NULL NULL float unsigned
967
NULL test tb2 f83 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
968
NULL test tb2 f84 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
969
NULL test tb2 f85 float NULL NULL NULL NULL float
970
NULL test tb2 f86 float NULL NULL NULL NULL float
971
NULL test tb2 f87 float unsigned NULL NULL NULL NULL float unsigned
972
NULL test tb2 f88 float unsigned NULL NULL NULL NULL float unsigned
973
NULL test tb2 f89 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
974
NULL test tb2 f90 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
975
NULL test tb2 f91 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
976
NULL test tb2 f92 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
977
NULL test tb2 f93 float NULL NULL NULL NULL float
978
NULL test tb2 f94 double NULL NULL NULL NULL double
979
NULL test tb2 f95 float unsigned NULL NULL NULL NULL float unsigned
980
NULL test tb2 f96 double unsigned NULL NULL NULL NULL double unsigned
981
NULL test tb2 f97 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
982
NULL test tb2 f98 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
983
NULL test tb2 f99 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
984
NULL test tb2 f100 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
985
NULL test tb2 f101 date NULL NULL NULL NULL date
986
NULL test tb2 f102 time NULL NULL NULL NULL time
987
NULL test tb2 f103 datetime NULL NULL NULL NULL datetime
988
NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp
989
NULL test tb2 f105 year NULL NULL NULL NULL year(4)
990
NULL test tb2 f106 year NULL NULL NULL NULL year(4)
991
NULL test tb2 f107 year NULL NULL NULL NULL year(4)
992
1.0000 test tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
993
1.0000 test tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
994
1.0000 test tb2 f110 varbinary 64 64 NULL NULL varbinary(64)
995
1.0000 test tb2 f111 varbinary 27 27 NULL NULL varbinary(27)
996
1.0000 test tb2 f112 varbinary 64 64 NULL NULL varbinary(64)
997
1.0000 test tb2 f113 varbinary 192 192 NULL NULL varbinary(192)
998
1.0000 test tb2 f114 varbinary 192 192 NULL NULL varbinary(192)
999
1.0000 test tb2 f115 varbinary 27 27 NULL NULL varbinary(27)
1000
1.0000 test tb2 f116 varbinary 64 64 NULL NULL varbinary(64)
1001
1.0000 test tb2 f117 varbinary 192 192 NULL NULL varbinary(192)
1002
1.0000 test tb3 f118 char 1 1 latin1 latin1_swedish_ci char(1)
1003
1.0000 test tb3 f119 char 1 1 latin1 latin1_bin char(1)
1004
1.0000 test tb3 f120 char 1 1 latin1 latin1_swedish_ci char(1)
1005
1.0000 test tb3 f121 tinytext 255 255 latin1 latin1_swedish_ci tinytext
1006
1.0000 test tb3 f122 text 65535 65535 latin1 latin1_swedish_ci text
1007
1.0000 test tb3 f123 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
1008
2.0000 test tb3 f124 longtext 2147483647 4294967295 ucs2 ucs2_general_ci longtext
1009
1.0000 test tb3 f125 tinyblob 255 255 NULL NULL tinyblob
1010
1.0000 test tb3 f126 blob 65535 65535 NULL NULL blob
1011
1.0000 test tb3 f127 mediumblob 16777215 16777215 NULL NULL mediumblob
1012
1.0000 test tb3 f128 longblob 4294967295 4294967295 NULL NULL longblob
1013
1.0000 test tb3 f129 binary 1 1 NULL NULL binary(1)
1014
NULL test tb3 f130 tinyint NULL NULL NULL NULL tinyint(4)
1015
NULL test tb3 f131 tinyint NULL NULL NULL NULL tinyint(3) unsigned
1016
NULL test tb3 f132 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1017
NULL test tb3 f133 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1018
NULL test tb3 f134 smallint NULL NULL NULL NULL smallint(6)
1019
NULL test tb3 f135 smallint NULL NULL NULL NULL smallint(5) unsigned
1020
NULL test tb3 f136 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1021
NULL test tb3 f137 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1022
NULL test tb3 f138 mediumint NULL NULL NULL NULL mediumint(9)
1023
NULL test tb3 f139 mediumint NULL NULL NULL NULL mediumint(8) unsigned
1024
NULL test tb3 f140 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1025
NULL test tb3 f141 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1026
NULL test tb3 f142 int NULL NULL NULL NULL int(11)
1027
NULL test tb3 f143 int NULL NULL NULL NULL int(10) unsigned
1028
NULL test tb3 f144 int NULL NULL NULL NULL int(10) unsigned zerofill
1029
NULL test tb3 f145 int NULL NULL NULL NULL int(10) unsigned zerofill
1030
NULL test tb3 f146 bigint NULL NULL NULL NULL bigint(20)
1031
NULL test tb3 f147 bigint NULL NULL NULL NULL bigint(20) unsigned
1032
NULL test tb3 f148 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1033
NULL test tb3 f149 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1034
NULL test tb3 f150 decimal NULL NULL NULL NULL decimal(10,0)
1035
NULL test tb3 f151 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1036
NULL test tb3 f152 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1037
NULL test tb3 f153 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1038
NULL test tb3 f154 decimal NULL NULL NULL NULL decimal(10,0)
1039
NULL test tb3 f155 decimal NULL NULL NULL NULL decimal(64,0)
1040
NULL test tb3 f156 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1041
NULL test tb3 f157 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1042
NULL test tb3 f158 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1043
NULL test tb3 f159 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1044
NULL test tb3 f160 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1045
NULL test tb3 f161 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1046
NULL test tb3 f162 decimal NULL NULL NULL NULL decimal(10,0)
1047
NULL test tb3 f163 decimal NULL NULL NULL NULL decimal(63,30)
1048
NULL test tb3 f164 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1049
NULL test tb3 f165 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1050
NULL test tb3 f166 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1051
NULL test tb3 f167 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1052
NULL test tb3 f168 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1053
NULL test tb3 f169 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1054
NULL test tb3 f170 decimal NULL NULL NULL NULL decimal(10,0)
1055
NULL test tb3 f171 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1056
NULL test tb3 f172 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1057
NULL test tb3 f173 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1058
NULL test tb3 f174 decimal NULL NULL NULL NULL decimal(10,0)
1059
NULL test tb3 f175 decimal NULL NULL NULL NULL decimal(64,0)
1060
NULL test tb4 f176 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1061
NULL test tb4 f177 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1062
NULL test tb4 f178 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1063
NULL test tb4 f179 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1064
NULL test tb4 f180 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1065
NULL test tb4 f181 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1066
NULL test tb4 f182 decimal NULL NULL NULL NULL decimal(10,0)
1067
NULL test tb4 f183 decimal NULL NULL NULL NULL decimal(63,30)
1068
NULL test tb4 f184 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1069
NULL test tb4 f185 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1070
NULL test tb4 f186 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1071
NULL test tb4 f187 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1072
NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1073
NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1074
NULL test tb4 f190 double NULL NULL NULL NULL double
1075
NULL test tb4 f191 double unsigned NULL NULL NULL NULL double unsigned
1076
NULL test tb4 f192 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1077
NULL test tb4 f193 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1078
NULL test tb4 f194 double NULL NULL NULL NULL double
1079
NULL test tb4 f195 double unsigned NULL NULL NULL NULL double unsigned
1080
NULL test tb4 f196 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1081
NULL test tb4 f197 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1082
NULL test tb4 f198 float NULL NULL NULL NULL float
1083
NULL test tb4 f199 float unsigned NULL NULL NULL NULL float unsigned
1084
NULL test tb4 f200 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1085
NULL test tb4 f201 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1086
NULL test tb4 f202 float NULL NULL NULL NULL float
1087
NULL test tb4 f203 float NULL NULL NULL NULL float
1088
NULL test tb4 f204 float unsigned NULL NULL NULL NULL float unsigned
1089
NULL test tb4 f205 float unsigned NULL NULL NULL NULL float unsigned
1090
NULL test tb4 f206 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1091
NULL test tb4 f207 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1092
NULL test tb4 f208 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1093
NULL test tb4 f209 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1094
NULL test tb4 f210 float NULL NULL NULL NULL float
1095
NULL test tb4 f211 double NULL NULL NULL NULL double
1096
NULL test tb4 f212 float unsigned NULL NULL NULL NULL float unsigned
1097
NULL test tb4 f213 double unsigned NULL NULL NULL NULL double unsigned
1098
NULL test tb4 f214 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1099
NULL test tb4 f215 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1100
NULL test tb4 f216 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1101
NULL test tb4 f217 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1102
NULL test tb4 f218 date NULL NULL NULL NULL date
1103
NULL test tb4 f219 time NULL NULL NULL NULL time
1104
NULL test tb4 f220 datetime NULL NULL NULL NULL datetime
1105
NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp
1106
NULL test tb4 f222 year NULL NULL NULL NULL year(4)
1107
NULL test tb4 f223 year NULL NULL NULL NULL year(4)
1108
NULL test tb4 f224 year NULL NULL NULL NULL year(4)
1109
1.0000 test tb4 f225 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1110
1.0000 test tb4 f226 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1111
1.0000 test tb4 f227 varbinary 64 64 NULL NULL varbinary(64)
1112
1.0000 test tb4 f228 varbinary 27 27 NULL NULL varbinary(27)
1113
1.0000 test tb4 f229 varbinary 64 64 NULL NULL varbinary(64)
1114
1.0000 test tb4 f230 varbinary 192 192 NULL NULL varbinary(192)
1115
1.0000 test tb4 f231 varbinary 192 192 NULL NULL varbinary(192)
1116
1.0000 test tb4 f232 varbinary 27 27 NULL NULL varbinary(27)
1117
1.0000 test tb4 f233 varbinary 64 64 NULL NULL varbinary(64)
1118
1.0000 test tb4 f234 varbinary 192 192 NULL NULL varbinary(192)
1119
2.0000 test tb4 f235 char 255 510 ucs2 ucs2_general_ci char(255)
1120
1.0000 test tb4 f236 char 60 60 latin1 latin1_swedish_ci char(60)
1121
1.0000 test tb4 f237 char 255 255 latin1 latin1_bin char(255)
1122
NULL test tb4 f238 varchar 0 0 latin1 latin1_bin varchar(0)
1123
1.0000 test tb4 f239 varbinary 1000 1000 NULL NULL varbinary(1000)
1124
2.0000 test tb4 f240 varchar 120 240 ucs2 ucs2_general_ci varchar(120)
1125
2.0000 test tb4 f241 char 100 200 ucs2 ucs2_general_ci char(100)
1126
NULL test tb4 f242 bit NULL NULL NULL NULL bit(30)
1127
NULL test1 tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1128
NULL test1 tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1129
NULL test1 tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1130
NULL test1 tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1131
NULL test1 tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1132
NULL test1 tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1133
NULL test1 tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
1134
NULL test1 tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
1135
NULL test1 tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1136
NULL test1 tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1137
NULL test1 tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1138
NULL test1 tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1139
NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1140
NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1141
NULL test1 tb2 f73 double NULL NULL NULL NULL double
1142
NULL test1 tb2 f74 double unsigned NULL NULL NULL NULL double unsigned
1143
NULL test1 tb2 f75 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1144
NULL test1 tb2 f76 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1145
NULL test1 tb2 f77 double NULL NULL NULL NULL double
1146
NULL test1 tb2 f78 double unsigned NULL NULL NULL NULL double unsigned
1147
NULL test1 tb2 f79 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1148
NULL test1 tb2 f80 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1149
NULL test1 tb2 f81 float NULL NULL NULL NULL float
1150
NULL test1 tb2 f82 float unsigned NULL NULL NULL NULL float unsigned
1151
NULL test1 tb2 f83 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1152
NULL test1 tb2 f84 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1153
NULL test1 tb2 f85 float NULL NULL NULL NULL float
1154
NULL test1 tb2 f86 float NULL NULL NULL NULL float
1155
NULL test1 tb2 f87 float unsigned NULL NULL NULL NULL float unsigned
1156
NULL test1 tb2 f88 float unsigned NULL NULL NULL NULL float unsigned
1157
NULL test1 tb2 f89 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1158
NULL test1 tb2 f90 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1159
NULL test1 tb2 f91 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1160
NULL test1 tb2 f92 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1161
NULL test1 tb2 f93 float NULL NULL NULL NULL float
1162
NULL test1 tb2 f94 double NULL NULL NULL NULL double
1163
NULL test1 tb2 f95 float unsigned NULL NULL NULL NULL float unsigned
1164
NULL test1 tb2 f96 double unsigned NULL NULL NULL NULL double unsigned
1165
NULL test1 tb2 f97 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1166
NULL test1 tb2 f98 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1167
NULL test1 tb2 f99 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1168
NULL test1 tb2 f100 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1169
NULL test1 tb2 f101 date NULL NULL NULL NULL date
1170
NULL test1 tb2 f102 time NULL NULL NULL NULL time
1171
NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime
1172
NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp
1173
NULL test1 tb2 f105 year NULL NULL NULL NULL year(4)
1174
NULL test1 tb2 f106 year NULL NULL NULL NULL year(4)
1175
NULL test1 tb2 f107 year NULL NULL NULL NULL year(4)
1176
1.0000 test1 tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1177
1.0000 test1 tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1178
1.0000 test1 tb2 f110 varbinary 64 64 NULL NULL varbinary(64)
1179
1.0000 test1 tb2 f111 varbinary 27 27 NULL NULL varbinary(27)
1180
1.0000 test1 tb2 f112 varbinary 64 64 NULL NULL varbinary(64)
1181
1.0000 test1 tb2 f113 varbinary 192 192 NULL NULL varbinary(192)
1182
1.0000 test1 tb2 f114 varbinary 192 192 NULL NULL varbinary(192)
1183
1.0000 test1 tb2 f115 varbinary 27 27 NULL NULL varbinary(27)
1184
1.0000 test1 tb2 f116 varbinary 64 64 NULL NULL varbinary(64)
1185
1.0000 test1 tb2 f117 varbinary 192 192 NULL NULL varbinary(192)
1186
1.0000 test4 t6 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1187
1.0000 test4 t6 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1188
NULL test4 t6 f3 date NULL NULL NULL NULL date
1189
NULL test4 t6 f4 int NULL NULL NULL NULL int(11)
1190
1.0000 test4 t6 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1191
NULL test4 t6 f6 int NULL NULL NULL NULL int(11)
1192
DROP DATABASE test1;
1193
DROP DATABASE test4;
1201
DROP TABLE test.t10;
1202
DROP TABLE test.t11;
1203
DROP TABLE test.tb1;
1204
DROP TABLE test.tb2;
1205
DROP TABLE test.tb3;
1206
DROP TABLE test.tb4;