46
46
show variables like "server_id%";
47
47
show variables like "SERVER_id%";
48
48
show variables like "this_doesn't_exists%";
49
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
50
49
show table status from test like "this_doesn't_exists%";
52
51
show databases like "test%";
210
209
insert into t1 values (1),(2);
211
210
insert into t2 values (1),(2);
212
211
insert into t3 values (1,1),(2,2);
213
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
212
--replace_column 6 # 7 # 8 # 9 #
214
213
show table status;
215
214
insert into t1 values (3),(4);
216
215
insert into t2 values (3),(4);
217
216
insert into t3 values (3,3),(4,4);
218
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
217
--replace_column 6 # 7 # 8 # 9 #
219
218
show table status;
220
219
insert into t1 values (5);
221
220
insert into t2 values (5);
222
221
insert into t3 values (5,5);
223
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
222
--replace_column 6 # 7 # 8 # 9 #
224
223
show table status;
225
224
delete from t1 where a=3;
226
225
delete from t2 where b=3;
227
226
delete from t3 where a=3;
228
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
227
--replace_column 6 # 7 # 8 # 9 # 10 #
229
228
show table status;
230
229
truncate table t1;
231
230
truncate table t2;
232
231
truncate table t3;
233
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
232
--replace_column 6 # 7 # 8 # 9 #
234
233
show table status;
235
234
insert into t1 values (5);
236
235
insert into t2 values (5);
237
236
insert into t3 values (5,5);
238
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
237
--replace_column 6 # 7 # 8 # 9 #
239
238
show table status;
240
239
delete from t1 where a=5;
241
240
delete from t2 where b=5;
242
241
delete from t3 where a=5;
243
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
242
--replace_column 6 # 7 # 8 # 9 # 10 #
244
243
show table status;
246
245
drop table t1, t2, t3;