|
1
by brian
clean slate |
1 |
connection master; |
2 |
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"); |
|
3 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
4 |
sync_slave_with_master; |
|
5 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
6 |
connection master; |
|
7 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
|
8 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
9 |
sync_slave_with_master; |
|
10 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
11 |
connection master; |
|
12 |
DELETE FROM mysqltest1.t1 WHERE id = 42; |
|
13 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
14 |
sync_slave_with_master; |
|
15 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
|
16 |
connection master; |