1 source include/master-slave.inc;
4 a int unsigned not null auto_increment primary key,
9 a int unsigned not null auto_increment primary key,
11 ) ENGINE=$engine_type;
13 INSERT INTO t1 VALUES (NULL, 0);
14 INSERT INTO t1 SELECT NULL, 0 FROM t1;
16 INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
18 SELECT * FROM t1 ORDER BY a;
19 SELECT * FROM t2 ORDER BY a;
21 UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a;
22 sync_slave_with_master;
29 --source include/rpl_end.inc