1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
stop slave; 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; start slave; create table t1 (a int primary key); create table t2 (a int); insert into t1 values (1); insert into t2 values (1); delete t1.* from t1, t2 where t1.a = t2.a; select * from t1; a select * from t2; a 1 select * from t1; a select * from t2; a 1 drop table t1,t2; |