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
DROP DATABASE IF EXISTS db_datadict;
401
CREATE DATABASE db_datadict;
404
IF(INSTR(table_comment,'InnoDB free') = 0
405
AND INSTR(table_comment,'number_of_replicas') = 0,
406
LENGTH(table_comment),
407
INSTR(table_comment,'InnoDB free')
408
+ INSTR(table_comment,'number_of_replicas') - 1))
410
'-----------------------------------------------------' AS "Separator"
411
FROM information_schema.tables
412
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
413
ORDER BY table_schema,table_name;
417
TABLE_TYPE BASE TABLE
424
MAX_DATA_LENGTH #MDL#
431
TABLE_COLLATION latin1_swedish_ci
436
Separator -----------------------------------------------------
440
TABLE_TYPE BASE TABLE
447
MAX_DATA_LENGTH #MDL#
454
TABLE_COLLATION latin1_swedish_ci
459
Separator -----------------------------------------------------
463
TABLE_TYPE BASE TABLE
470
MAX_DATA_LENGTH #MDL#
477
TABLE_COLLATION latin1_swedish_ci
482
Separator -----------------------------------------------------
486
TABLE_TYPE BASE TABLE
493
MAX_DATA_LENGTH #MDL#
500
TABLE_COLLATION latin1_swedish_ci
505
Separator -----------------------------------------------------
509
TABLE_TYPE BASE TABLE
516
MAX_DATA_LENGTH #MDL#
523
TABLE_COLLATION latin1_swedish_ci
528
Separator -----------------------------------------------------
532
TABLE_TYPE BASE TABLE
539
MAX_DATA_LENGTH #MDL#
546
TABLE_COLLATION latin1_swedish_ci
551
Separator -----------------------------------------------------
555
TABLE_TYPE BASE TABLE
562
MAX_DATA_LENGTH #MDL#
569
TABLE_COLLATION latin1_swedish_ci
574
Separator -----------------------------------------------------
578
TABLE_TYPE BASE TABLE
585
MAX_DATA_LENGTH #MDL#
592
TABLE_COLLATION latin1_swedish_ci
597
Separator -----------------------------------------------------
601
TABLE_TYPE BASE TABLE
608
MAX_DATA_LENGTH #MDL#
615
TABLE_COLLATION latin1_swedish_ci
620
Separator -----------------------------------------------------
624
TABLE_TYPE BASE TABLE
631
MAX_DATA_LENGTH #MDL#
638
TABLE_COLLATION latin1_swedish_ci
643
Separator -----------------------------------------------------
647
TABLE_TYPE BASE TABLE
654
MAX_DATA_LENGTH #MDL#
661
TABLE_COLLATION latin1_swedish_ci
666
Separator -----------------------------------------------------
670
TABLE_TYPE BASE TABLE
677
MAX_DATA_LENGTH #MDL#
684
TABLE_COLLATION latin1_swedish_ci
689
Separator -----------------------------------------------------
693
TABLE_TYPE BASE TABLE
700
MAX_DATA_LENGTH #MDL#
707
TABLE_COLLATION latin1_swedish_ci
712
Separator -----------------------------------------------------
716
TABLE_TYPE BASE TABLE
723
MAX_DATA_LENGTH #MDL#
730
TABLE_COLLATION latin1_swedish_ci
735
Separator -----------------------------------------------------
739
TABLE_TYPE BASE TABLE
746
MAX_DATA_LENGTH #MDL#
753
TABLE_COLLATION latin1_swedish_ci
758
Separator -----------------------------------------------------
759
DROP USER testuser1@localhost;
760
CREATE USER testuser1@localhost;
761
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
762
# Establish connection testuser1 (user=testuser1)
765
IF(INSTR(table_comment,'InnoDB free') = 0
766
AND INSTR(table_comment,'number_of_replicas') = 0,
767
LENGTH(table_comment),
768
INSTR(table_comment,'InnoDB free')
769
+ INSTR(table_comment,'number_of_replicas') - 1))
771
'-----------------------------------------------------' AS "Separator"
772
FROM information_schema.tables
773
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
774
ORDER BY table_schema,table_name;
778
TABLE_TYPE BASE TABLE
785
MAX_DATA_LENGTH #MDL#
792
TABLE_COLLATION latin1_swedish_ci
797
Separator -----------------------------------------------------
801
TABLE_TYPE BASE TABLE
808
MAX_DATA_LENGTH #MDL#
815
TABLE_COLLATION latin1_swedish_ci
820
Separator -----------------------------------------------------
824
TABLE_TYPE BASE TABLE
831
MAX_DATA_LENGTH #MDL#
838
TABLE_COLLATION latin1_swedish_ci
843
Separator -----------------------------------------------------
847
TABLE_TYPE BASE TABLE
854
MAX_DATA_LENGTH #MDL#
861
TABLE_COLLATION latin1_swedish_ci
866
Separator -----------------------------------------------------
870
TABLE_TYPE BASE TABLE
877
MAX_DATA_LENGTH #MDL#
884
TABLE_COLLATION latin1_swedish_ci
889
Separator -----------------------------------------------------
893
TABLE_TYPE BASE TABLE
900
MAX_DATA_LENGTH #MDL#
907
TABLE_COLLATION latin1_swedish_ci
912
Separator -----------------------------------------------------
916
TABLE_TYPE BASE TABLE
923
MAX_DATA_LENGTH #MDL#
930
TABLE_COLLATION latin1_swedish_ci
935
Separator -----------------------------------------------------
939
TABLE_TYPE BASE TABLE
946
MAX_DATA_LENGTH #MDL#
953
TABLE_COLLATION latin1_swedish_ci
958
Separator -----------------------------------------------------
962
TABLE_TYPE BASE TABLE
969
MAX_DATA_LENGTH #MDL#
976
TABLE_COLLATION latin1_swedish_ci
981
Separator -----------------------------------------------------
985
TABLE_TYPE BASE TABLE
992
MAX_DATA_LENGTH #MDL#
999
TABLE_COLLATION latin1_swedish_ci
1004
Separator -----------------------------------------------------
1008
TABLE_TYPE BASE TABLE
1013
AVG_ROW_LENGTH #ARL#
1015
MAX_DATA_LENGTH #MDL#
1022
TABLE_COLLATION latin1_swedish_ci
1027
Separator -----------------------------------------------------
1031
TABLE_TYPE BASE TABLE
1036
AVG_ROW_LENGTH #ARL#
1038
MAX_DATA_LENGTH #MDL#
1045
TABLE_COLLATION latin1_swedish_ci
1050
Separator -----------------------------------------------------
1054
TABLE_TYPE BASE TABLE
1059
AVG_ROW_LENGTH #ARL#
1061
MAX_DATA_LENGTH #MDL#
1068
TABLE_COLLATION latin1_swedish_ci
1073
Separator -----------------------------------------------------
1074
# Switch to connection default and close connection testuser1
1075
DROP USER testuser1@localhost;
1076
DROP DATABASE db_datadict;
1077
DROP DATABASE test1;
1078
DROP DATABASE test4;
1086
DROP TABLE test.t10;
1087
DROP TABLE test.t11;
1088
DROP TABLE test.tb1;
1089
DROP TABLE test.tb2;
1090
DROP TABLE test.tb3;
1091
DROP TABLE test.tb4;