1 include/master-slave.inc
3 drop database if exists d1;
4 drop database if exists d2;
5 drop database if exists d2;
7 create table d1.t0 (id int);
10 create table t1 (id int);
11 create table t2 (id int);
12 insert into t1 values (1), (2), (3), (4), (5);
13 insert into t2 select id + 3 from t1;
14 update t1 join t2 using (id) set t1.id = 0;
15 insert into d1.t0 values (0);
17 select * from t0 where id=0;