slave stop;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;reset master;reset slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;slave start;drop table if exists t1,t2;CREATE TABLE t1 (a int unsigned not null auto_increment primary key,b int unsigned,) TYPE=MyISAM;CREATE TABLE t2 (a int unsigned not null auto_increment primary key,b int unsigned) TYPE=MyISAM;INSERT INTO t1 VALUES (NULL, 0);INSERT INTO t1 SELECT NULL, 0 FROM t1;INSERT INTO t2 VALUES (NULL, 0), (NULL,1);SELECT * FROM t1 ORDER BY a;a b1 02 0SELECT * FROM t2 ORDER BY a;a b1 02 1UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a;