rpl_multi_update2.result 768 Bytes
Newer Older
unknown's avatar
unknown committed
1
stop slave;
unknown's avatar
unknown committed
2 3 4 5
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;
unknown's avatar
unknown committed
6
start slave;
unknown's avatar
unknown committed
7 8 9
CREATE TABLE t1 (
a int unsigned not null auto_increment primary key,
b int unsigned
unknown's avatar
unknown committed
10
) ENGINE=MyISAM;
unknown's avatar
unknown committed
11 12 13
CREATE TABLE t2 (
a int unsigned not null auto_increment primary key,
b int unsigned
unknown's avatar
unknown committed
14
) ENGINE=MyISAM;
unknown's avatar
unknown committed
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
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	b
1	0
2	0
SELECT * FROM t2 ORDER BY a;
a	b
1	0
2	1
UPDATE t1, t2 SET t1.b = (t2.b+4) WHERE t1.a = t2.a;
SELECT * FROM t1 ORDER BY a;
a	b
1	4
2	5
SELECT * FROM t2 ORDER BY a;
a	b
1	0
2	1
SELECT * FROM t1 ORDER BY a;
a	b
1	4
2	5
SELECT * FROM t2 ORDER BY a;
a	b
1	0
2	1