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