2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
create database if not exists mysqltest1;
9
drop table if exists t1;
10
CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
11
VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
12
0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP,PRIMARY KEY(id));
14
alter table t1 engine=myisam;
17
t1 CREATE TABLE `t1` (
18
`id` mediumint(9) NOT NULL,
19
`b1` bit(8) DEFAULT NULL,
20
`vc` varchar(255) DEFAULT NULL,
21
`bc` char(255) DEFAULT NULL,
22
`d` decimal(10,4) DEFAULT '0.0000',
23
`f` float DEFAULT '0',
24
`total` bigint(20) unsigned DEFAULT NULL,
25
`y` year(4) DEFAULT NULL,
26
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
28
) ENGINE=MyISAM DEFAULT CHARSET=latin1
29
alter table t1 engine=myisam;
32
t1 CREATE TABLE `t1` (
33
`id` mediumint(9) NOT NULL,
34
`b1` bit(8) DEFAULT NULL,
35
`vc` varchar(255) DEFAULT NULL,
36
`bc` char(255) DEFAULT NULL,
37
`d` decimal(10,4) DEFAULT '0.0000',
38
`f` float DEFAULT '0',
39
`total` bigint(20) unsigned DEFAULT NULL,
40
`y` year(4) DEFAULT NULL,
41
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
43
) ENGINE=MyISAM DEFAULT CHARSET=latin1
44
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
45
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
46
id hex(b1) vc bc d f total y t
47
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
48
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
49
id hex(b1) vc bc d f total y t
50
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
51
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
52
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
53
id hex(b1) vc bc d f total y t
54
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
55
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
56
id hex(b1) vc bc d f total y t
57
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
58
DELETE FROM mysqltest1.t1 WHERE id = 42;
59
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
60
id hex(b1) vc bc d f total y t
61
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
62
id hex(b1) vc bc d f total y t
63
alter table t1 engine=innodb;
66
t1 CREATE TABLE `t1` (
67
`id` mediumint(9) NOT NULL,
68
`b1` bit(8) DEFAULT NULL,
69
`vc` varchar(255) DEFAULT NULL,
70
`bc` char(255) DEFAULT NULL,
71
`d` decimal(10,4) DEFAULT '0.0000',
72
`f` float DEFAULT '0',
73
`total` bigint(20) unsigned DEFAULT NULL,
74
`y` year(4) DEFAULT NULL,
75
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
77
) ENGINE=InnoDB DEFAULT CHARSET=latin1
78
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
79
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
80
id hex(b1) vc bc d f total y t
81
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
82
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
83
id hex(b1) vc bc d f total y t
84
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
85
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
86
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
87
id hex(b1) vc bc d f total y t
88
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
89
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
90
id hex(b1) vc bc d f total y t
91
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
92
DELETE FROM mysqltest1.t1 WHERE id = 42;
93
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
94
id hex(b1) vc bc d f total y t
95
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
96
id hex(b1) vc bc d f total y t
97
alter table t1 engine=memory;
100
t1 CREATE TABLE `t1` (
101
`id` mediumint(9) NOT NULL,
102
`b1` bit(8) DEFAULT NULL,
103
`vc` varchar(255) DEFAULT NULL,
104
`bc` char(255) DEFAULT NULL,
105
`d` decimal(10,4) DEFAULT '0.0000',
106
`f` float DEFAULT '0',
107
`total` bigint(20) unsigned DEFAULT NULL,
108
`y` year(4) DEFAULT NULL,
109
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
111
) ENGINE=MEMORY DEFAULT CHARSET=latin1
112
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
113
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
114
id hex(b1) vc bc d f total y t
115
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
116
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
117
id hex(b1) vc bc d f total y t
118
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
119
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
120
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
121
id hex(b1) vc bc d f total y t
122
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
123
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
124
id hex(b1) vc bc d f total y t
125
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
126
DELETE FROM mysqltest1.t1 WHERE id = 42;
127
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
128
id hex(b1) vc bc d f total y t
129
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
130
id hex(b1) vc bc d f total y t
131
alter table t1 engine=memory;
132
show create table t1;
134
t1 CREATE TABLE `t1` (
135
`id` mediumint(9) NOT NULL,
136
`b1` bit(8) DEFAULT NULL,
137
`vc` varchar(255) DEFAULT NULL,
138
`bc` char(255) DEFAULT NULL,
139
`d` decimal(10,4) DEFAULT '0.0000',
140
`f` float DEFAULT '0',
141
`total` bigint(20) unsigned DEFAULT NULL,
142
`y` year(4) DEFAULT NULL,
143
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
145
) ENGINE=MEMORY DEFAULT CHARSET=latin1
146
alter table t1 engine=myisam;
147
show create table t1;
149
t1 CREATE TABLE `t1` (
150
`id` mediumint(9) NOT NULL,
151
`b1` bit(8) DEFAULT NULL,
152
`vc` varchar(255) DEFAULT NULL,
153
`bc` char(255) DEFAULT NULL,
154
`d` decimal(10,4) DEFAULT '0.0000',
155
`f` float DEFAULT '0',
156
`total` bigint(20) unsigned DEFAULT NULL,
157
`y` year(4) DEFAULT NULL,
158
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
160
) ENGINE=MyISAM DEFAULT CHARSET=latin1
161
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
162
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
163
id hex(b1) vc bc d f total y t
164
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
165
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
166
id hex(b1) vc bc d f total y t
167
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
168
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
169
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
170
id hex(b1) vc bc d f total y t
171
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
172
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
173
id hex(b1) vc bc d f total y t
174
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
175
DELETE FROM mysqltest1.t1 WHERE id = 42;
176
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
177
id hex(b1) vc bc d f total y t
178
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
179
id hex(b1) vc bc d f total y t
180
alter table t1 engine=innodb;
181
show create table t1;
183
t1 CREATE TABLE `t1` (
184
`id` mediumint(9) NOT NULL,
185
`b1` bit(8) DEFAULT NULL,
186
`vc` varchar(255) DEFAULT NULL,
187
`bc` char(255) DEFAULT NULL,
188
`d` decimal(10,4) DEFAULT '0.0000',
189
`f` float DEFAULT '0',
190
`total` bigint(20) unsigned DEFAULT NULL,
191
`y` year(4) DEFAULT NULL,
192
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
194
) ENGINE=InnoDB DEFAULT CHARSET=latin1
195
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
196
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
197
id hex(b1) vc bc d f total y t
198
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
199
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
200
id hex(b1) vc bc d f total y t
201
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
202
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
203
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
204
id hex(b1) vc bc d f total y t
205
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
206
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
207
id hex(b1) vc bc d f total y t
208
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
209
DELETE FROM mysqltest1.t1 WHERE id = 42;
210
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
211
id hex(b1) vc bc d f total y t
212
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
213
id hex(b1) vc bc d f total y t
214
alter table t1 engine=memory;
215
show create table t1;
217
t1 CREATE TABLE `t1` (
218
`id` mediumint(9) NOT NULL,
219
`b1` bit(8) DEFAULT NULL,
220
`vc` varchar(255) DEFAULT NULL,
221
`bc` char(255) DEFAULT NULL,
222
`d` decimal(10,4) DEFAULT '0.0000',
223
`f` float DEFAULT '0',
224
`total` bigint(20) unsigned DEFAULT NULL,
225
`y` year(4) DEFAULT NULL,
226
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
228
) ENGINE=MEMORY DEFAULT CHARSET=latin1
229
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
230
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
231
id hex(b1) vc bc d f total y t
232
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
233
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
234
id hex(b1) vc bc d f total y t
235
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
236
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
237
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
238
id hex(b1) vc bc d f total y t
239
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
240
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
241
id hex(b1) vc bc d f total y t
242
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
243
DELETE FROM mysqltest1.t1 WHERE id = 42;
244
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
245
id hex(b1) vc bc d f total y t
246
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
247
id hex(b1) vc bc d f total y t
248
alter table t1 engine=innodb;
249
show create table t1;
251
t1 CREATE TABLE `t1` (
252
`id` mediumint(9) NOT NULL,
253
`b1` bit(8) DEFAULT NULL,
254
`vc` varchar(255) DEFAULT NULL,
255
`bc` char(255) DEFAULT NULL,
256
`d` decimal(10,4) DEFAULT '0.0000',
257
`f` float DEFAULT '0',
258
`total` bigint(20) unsigned DEFAULT NULL,
259
`y` year(4) DEFAULT NULL,
260
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
262
) ENGINE=InnoDB DEFAULT CHARSET=latin1
263
alter table t1 engine=myisam;
264
show create table t1;
266
t1 CREATE TABLE `t1` (
267
`id` mediumint(9) NOT NULL,
268
`b1` bit(8) DEFAULT NULL,
269
`vc` varchar(255) DEFAULT NULL,
270
`bc` char(255) DEFAULT NULL,
271
`d` decimal(10,4) DEFAULT '0.0000',
272
`f` float DEFAULT '0',
273
`total` bigint(20) unsigned DEFAULT NULL,
274
`y` year(4) DEFAULT NULL,
275
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
277
) ENGINE=MyISAM DEFAULT CHARSET=latin1
278
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
279
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
280
id hex(b1) vc bc d f total y t
281
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
282
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
283
id hex(b1) vc bc d f total y t
284
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
285
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
286
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
287
id hex(b1) vc bc d f total y t
288
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
289
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
290
id hex(b1) vc bc d f total y t
291
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
292
DELETE FROM mysqltest1.t1 WHERE id = 42;
293
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
294
id hex(b1) vc bc d f total y t
295
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
296
id hex(b1) vc bc d f total y t
297
alter table t1 engine=innodb;
298
show create table t1;
300
t1 CREATE TABLE `t1` (
301
`id` mediumint(9) NOT NULL,
302
`b1` bit(8) DEFAULT NULL,
303
`vc` varchar(255) DEFAULT NULL,
304
`bc` char(255) DEFAULT NULL,
305
`d` decimal(10,4) DEFAULT '0.0000',
306
`f` float DEFAULT '0',
307
`total` bigint(20) unsigned DEFAULT NULL,
308
`y` year(4) DEFAULT NULL,
309
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
311
) ENGINE=InnoDB DEFAULT CHARSET=latin1
312
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
313
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
314
id hex(b1) vc bc d f total y t
315
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
316
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
317
id hex(b1) vc bc d f total y t
318
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
319
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
320
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
321
id hex(b1) vc bc d f total y t
322
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
323
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
324
id hex(b1) vc bc d f total y t
325
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
326
DELETE FROM mysqltest1.t1 WHERE id = 42;
327
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
328
id hex(b1) vc bc d f total y t
329
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
330
id hex(b1) vc bc d f total y t
331
alter table t1 engine=memory;
332
show create table t1;
334
t1 CREATE TABLE `t1` (
335
`id` mediumint(9) NOT NULL,
336
`b1` bit(8) DEFAULT NULL,
337
`vc` varchar(255) DEFAULT NULL,
338
`bc` char(255) DEFAULT NULL,
339
`d` decimal(10,4) DEFAULT '0.0000',
340
`f` float DEFAULT '0',
341
`total` bigint(20) unsigned DEFAULT NULL,
342
`y` year(4) DEFAULT NULL,
343
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
345
) ENGINE=MEMORY DEFAULT CHARSET=latin1
346
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
347
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
348
id hex(b1) vc bc d f total y t
349
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
350
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
351
id hex(b1) vc bc d f total y t
352
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
353
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
354
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
355
id hex(b1) vc bc d f total y t
356
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
357
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
358
id hex(b1) vc bc d f total y t
359
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
360
DELETE FROM mysqltest1.t1 WHERE id = 42;
361
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
362
id hex(b1) vc bc d f total y t
363
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
364
id hex(b1) vc bc d f total y t
366
DROP DATABASE mysqltest1;