1include/master-slave.inc 2[connection master] 3connection slave; 4create database mysqltest; 5connection master; 6drop database if exists mysqltest; 7Warnings: 8Note 1008 Can't drop database 'mysqltest'; database doesn't exist 9connection slave; 10show tables from mysqltest; 11ERROR 42000: Unknown database 'mysqltest' 12connection slave; 13create table t1 (a int); 14connection master; 15drop table if exists t1; 16Warnings: 17Note 1051 Unknown table 'test.t1' 18connection slave; 19select * from t1; 20ERROR 42S02: Table 'test.t1' doesn't exist 21connection master; 22create table t1 (a int, b int); 23connection slave; 24insert into t1 values(1,1); 25connection master; 26delete from t1; 27connection slave; 28select * from t1; 29a b 30insert into t1 values(1,1); 31connection master; 32insert into t1 values(2,1); 33update t1 set a=2; 34connection slave; 35select * from t1; 36a b 372 1 382 1 39connection master; 40create table t2 (a int, b int); 41delete from t1; 42insert into t1 values(1,1); 43insert into t2 values(1,1); 44connection slave; 45update t1 set a=2; 46connection master; 47UPDATE t1, t2 SET t1.a = t2.a; 48connection slave; 49select * from t1; 50a b 511 1 52select * from t2; 53a b 541 1 55connection master; 56delete from t1; 57delete from t2; 58connection slave; 59insert into t1 values(1,1); 60insert into t2 values(1,1); 61connection master; 62DELETE t1.*, t2.* from t1, t2; 63connection slave; 64select * from t1; 65a b 66select * from t2; 67a b 68connection master; 69drop table t1, t2; 70connection slave; 71include/rpl_end.inc 72