8
8
VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
9
9
0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
10
10
ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id));
11
alter table t1 engine=myisam;
14
t1 CREATE TABLE `t1` (
15
`id` mediumint(9) NOT NULL,
16
`b1` bit(8) DEFAULT NULL,
17
`vc` varchar(255) DEFAULT NULL,
18
`bc` char(255) DEFAULT NULL,
19
`d` decimal(10,4) DEFAULT '0.0000',
20
`f` float DEFAULT '0',
21
`total` bigint(20) unsigned DEFAULT NULL,
22
`y` year(4) DEFAULT NULL,
23
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
25
) ENGINE=MyISAM DEFAULT CHARSET=latin1
26
alter table t1 engine=myisam;
29
t1 CREATE TABLE `t1` (
30
`id` mediumint(9) NOT NULL,
31
`b1` bit(8) DEFAULT NULL,
32
`vc` varchar(255) DEFAULT NULL,
33
`bc` char(255) DEFAULT NULL,
34
`d` decimal(10,4) DEFAULT '0.0000',
35
`f` float DEFAULT '0',
36
`total` bigint(20) unsigned DEFAULT NULL,
37
`y` year(4) DEFAULT NULL,
38
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
40
) ENGINE=MyISAM DEFAULT CHARSET=latin1
41
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");
42
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
43
id hex(b1) vc bc d f total y t
44
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
49
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
50
id hex(b1) vc bc d f total y t
51
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
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
DELETE FROM t1 WHERE id = 42;
56
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
57
id hex(b1) vc bc d f total y t
58
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
59
id hex(b1) vc bc d f total y t
60
alter table t1 engine=innodb;
63
t1 CREATE TABLE `t1` (
64
`id` mediumint(9) NOT NULL,
65
`b1` bit(8) DEFAULT NULL,
66
`vc` varchar(255) DEFAULT NULL,
67
`bc` char(255) DEFAULT NULL,
68
`d` decimal(10,4) DEFAULT '0.0000',
69
`f` float DEFAULT '0',
70
`total` bigint(20) unsigned DEFAULT NULL,
71
`y` year(4) DEFAULT NULL,
72
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
74
) ENGINE=InnoDB DEFAULT CHARSET=latin1
75
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");
76
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
77
id hex(b1) vc bc d f total y t
78
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
83
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
84
id hex(b1) vc bc d f total y t
85
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
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
DELETE FROM t1 WHERE id = 42;
90
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
91
id hex(b1) vc bc d f total y t
92
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
93
id hex(b1) vc bc d f total y t
94
alter table t1 engine=memory;
97
t1 CREATE TABLE `t1` (
98
`id` mediumint(9) NOT NULL,
99
`b1` bit(8) DEFAULT NULL,
100
`vc` varchar(255) DEFAULT NULL,
101
`bc` char(255) DEFAULT NULL,
102
`d` decimal(10,4) DEFAULT '0.0000',
103
`f` float DEFAULT '0',
104
`total` bigint(20) unsigned DEFAULT NULL,
105
`y` year(4) DEFAULT NULL,
106
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
108
) ENGINE=MEMORY DEFAULT CHARSET=latin1
109
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");
110
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
111
id hex(b1) vc bc d f total y t
112
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
117
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
118
id hex(b1) vc bc d f total y t
119
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
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
DELETE FROM t1 WHERE id = 42;
124
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
125
id hex(b1) vc bc d f total y t
126
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
127
id hex(b1) vc bc d f total y t
128
alter table t1 engine=memory;
129
show create table t1;
131
t1 CREATE TABLE `t1` (
132
`id` mediumint(9) NOT NULL,
133
`b1` bit(8) DEFAULT NULL,
134
`vc` varchar(255) DEFAULT NULL,
135
`bc` char(255) DEFAULT NULL,
136
`d` decimal(10,4) DEFAULT '0.0000',
137
`f` float DEFAULT '0',
138
`total` bigint(20) unsigned DEFAULT NULL,
139
`y` year(4) DEFAULT NULL,
140
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
142
) ENGINE=MEMORY DEFAULT CHARSET=latin1
143
alter table t1 engine=myisam;
144
show create table t1;
146
t1 CREATE TABLE `t1` (
147
`id` mediumint(9) NOT NULL,
148
`b1` bit(8) DEFAULT NULL,
149
`vc` varchar(255) DEFAULT NULL,
150
`bc` char(255) DEFAULT NULL,
151
`d` decimal(10,4) DEFAULT '0.0000',
152
`f` float DEFAULT '0',
153
`total` bigint(20) unsigned DEFAULT NULL,
154
`y` year(4) DEFAULT NULL,
155
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
157
) ENGINE=MyISAM DEFAULT CHARSET=latin1
158
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");
159
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
160
id hex(b1) vc bc d f total y t
161
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
166
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
167
id hex(b1) vc bc d f total y t
168
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
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
DELETE FROM t1 WHERE id = 42;
173
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
174
id hex(b1) vc bc d f total y t
175
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
176
id hex(b1) vc bc d f total y t
177
alter table t1 engine=innodb;
178
show create table t1;
180
t1 CREATE TABLE `t1` (
181
`id` mediumint(9) NOT NULL,
182
`b1` bit(8) DEFAULT NULL,
183
`vc` varchar(255) DEFAULT NULL,
184
`bc` char(255) DEFAULT NULL,
185
`d` decimal(10,4) DEFAULT '0.0000',
186
`f` float DEFAULT '0',
187
`total` bigint(20) unsigned DEFAULT NULL,
188
`y` year(4) DEFAULT NULL,
189
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
191
) ENGINE=InnoDB DEFAULT CHARSET=latin1
192
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");
193
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
194
id hex(b1) vc bc d f total y t
195
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
200
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
201
id hex(b1) vc bc d f total y t
202
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
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
DELETE FROM t1 WHERE id = 42;
207
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
208
id hex(b1) vc bc d f total y t
209
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
210
id hex(b1) vc bc d f total y t
211
alter table t1 engine=memory;
212
show create table t1;
214
t1 CREATE TABLE `t1` (
215
`id` mediumint(9) NOT NULL,
216
`b1` bit(8) DEFAULT NULL,
217
`vc` varchar(255) DEFAULT NULL,
218
`bc` char(255) DEFAULT NULL,
219
`d` decimal(10,4) DEFAULT '0.0000',
220
`f` float DEFAULT '0',
221
`total` bigint(20) unsigned DEFAULT NULL,
222
`y` year(4) DEFAULT NULL,
223
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
225
) ENGINE=MEMORY DEFAULT CHARSET=latin1
226
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");
227
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
228
id hex(b1) vc bc d f total y t
229
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
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
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
234
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
235
id hex(b1) vc bc d f total y t
236
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
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
DELETE FROM t1 WHERE id = 42;
241
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
242
id hex(b1) vc bc d f total y t
243
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
244
id hex(b1) vc bc d f total y t
245
alter table t1 engine=innodb;
246
show create table t1;
248
t1 CREATE TABLE `t1` (
249
`id` mediumint(9) NOT NULL,
250
`b1` bit(8) DEFAULT NULL,
251
`vc` varchar(255) DEFAULT NULL,
252
`bc` char(255) DEFAULT NULL,
253
`d` decimal(10,4) DEFAULT '0.0000',
254
`f` float DEFAULT '0',
255
`total` bigint(20) unsigned DEFAULT NULL,
256
`y` year(4) DEFAULT NULL,
257
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
259
) ENGINE=InnoDB DEFAULT CHARSET=latin1
11
include/sync_slave_sql_with_master.inc
12
alter table t1 engine=myisam;
15
t1 CREATE TABLE `t1` (
16
`id` mediumint(9) NOT NULL,
17
`b1` bit(8) DEFAULT NULL,
18
`vc` varchar(255) DEFAULT NULL,
19
`bc` char(255) DEFAULT NULL,
20
`d` decimal(10,4) DEFAULT '0.0000',
21
`f` float DEFAULT '0',
22
`total` bigint(20) unsigned DEFAULT NULL,
23
`y` year(4) DEFAULT NULL,
24
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
26
) ENGINE=MyISAM DEFAULT CHARSET=latin1
27
include/sync_slave_sql_with_master.inc
28
alter table t1 engine=myisam;
31
t1 CREATE TABLE `t1` (
32
`id` mediumint(9) NOT NULL,
33
`b1` bit(8) DEFAULT NULL,
34
`vc` varchar(255) DEFAULT NULL,
35
`bc` char(255) DEFAULT NULL,
36
`d` decimal(10,4) DEFAULT '0.0000',
37
`f` float DEFAULT '0',
38
`total` bigint(20) unsigned DEFAULT NULL,
39
`y` year(4) DEFAULT NULL,
40
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
42
) ENGINE=MyISAM DEFAULT CHARSET=latin1
43
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");
44
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
45
id hex(b1) vc bc d f total y t
46
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
47
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
48
id hex(b1) vc bc d f total y t
49
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
50
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
51
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
52
id hex(b1) vc bc d f total y t
53
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
54
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
55
id hex(b1) vc bc d f total y t
56
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
57
DELETE FROM t1 WHERE id = 42;
58
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
59
id hex(b1) vc bc d f total y t
60
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
61
id hex(b1) vc bc d f total y t
62
alter table t1 engine=innodb;
65
t1 CREATE TABLE `t1` (
66
`id` mediumint(9) NOT NULL,
67
`b1` bit(8) DEFAULT NULL,
68
`vc` varchar(255) DEFAULT NULL,
69
`bc` char(255) DEFAULT NULL,
70
`d` decimal(10,4) DEFAULT '0.0000',
71
`f` float DEFAULT '0',
72
`total` bigint(20) unsigned DEFAULT NULL,
73
`y` year(4) DEFAULT NULL,
74
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
76
) ENGINE=InnoDB DEFAULT CHARSET=latin1
77
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");
78
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
79
id hex(b1) vc bc d f total y t
80
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
81
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
82
id hex(b1) vc bc d f total y t
83
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
84
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
85
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
86
id hex(b1) vc bc d f total y t
87
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
88
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
89
id hex(b1) vc bc d f total y t
90
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
91
DELETE FROM t1 WHERE id = 42;
92
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
93
id hex(b1) vc bc d f total y t
94
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
95
id hex(b1) vc bc d f total y t
96
alter table t1 engine=memory;
99
t1 CREATE TABLE `t1` (
100
`id` mediumint(9) NOT NULL,
101
`b1` bit(8) DEFAULT NULL,
102
`vc` varchar(255) DEFAULT NULL,
103
`bc` char(255) DEFAULT NULL,
104
`d` decimal(10,4) DEFAULT '0.0000',
105
`f` float DEFAULT '0',
106
`total` bigint(20) unsigned DEFAULT NULL,
107
`y` year(4) DEFAULT NULL,
108
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
110
) ENGINE=MEMORY DEFAULT CHARSET=latin1
111
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");
112
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
113
id hex(b1) vc bc d f total y t
114
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
115
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
116
id hex(b1) vc bc d f total y t
117
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
118
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
119
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
120
id hex(b1) vc bc d f total y t
121
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
122
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
123
id hex(b1) vc bc d f total y t
124
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
125
DELETE FROM t1 WHERE id = 42;
126
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
127
id hex(b1) vc bc d f total y t
128
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
129
id hex(b1) vc bc d f total y t
130
alter table t1 engine=memory;
131
show create table t1;
133
t1 CREATE TABLE `t1` (
134
`id` mediumint(9) NOT NULL,
135
`b1` bit(8) DEFAULT NULL,
136
`vc` varchar(255) DEFAULT NULL,
137
`bc` char(255) DEFAULT NULL,
138
`d` decimal(10,4) DEFAULT '0.0000',
139
`f` float DEFAULT '0',
140
`total` bigint(20) unsigned DEFAULT NULL,
141
`y` year(4) DEFAULT NULL,
142
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
144
) ENGINE=MEMORY DEFAULT CHARSET=latin1
145
include/sync_slave_sql_with_master.inc
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 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 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 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
include/sync_slave_sql_with_master.inc
260
264
alter table t1 engine=myisam;
261
265
show create table t1;
262
266
Table Create Table