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