1include/master-slave.inc 2[connection master] 3drop table if exists t11; 4connection slave; 5drop table if exists t11; 6create table t2 (n int); 7insert into t2 values(4); 8connection master; 9create table t2 (s char(20)); 10load data infile '../../std_data/words.dat' into table t2; 11insert into t2 values('five'); 12create table t1 (m int); 13insert into t1 values(15),(16),(17); 14update t1 set m=20 where m=16; 15delete from t1 where m=17; 16create table t11 select * from t1; 17connection slave; 18select * from t1 ORDER BY m; 19m 2015 2120 22select * from t2; 23n 244 25select * from t11; 26ERROR 42S02: Table 'test.t11' doesn't exist 27connection master; 28drop table if exists t1,t2,t11; 29connection slave; 30Replicate_Do_Table = 'test.t1' 31connection master; 32create table t1 (a int, b int); 33create trigger trg1 before insert on t1 for each row set new.b=2; 34create table t2 (a int, b int); 35create trigger trg2 before insert on t2 for each row set new.b=2; 36show tables; 37Tables_in_test 38t1 39t2 40show triggers; 41Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 42trg1 INSERT t1 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci 43trg2 INSERT t2 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci 44connection slave; 45connection slave; 46show tables; 47Tables_in_test 48t1 49show triggers; 50Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 51trg1 INSERT t1 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci 52connection master; 53drop trigger trg1; 54drop trigger trg2; 55show triggers; 56Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 57connection slave; 58connection slave; 59show tables; 60Tables_in_test 61t1 62show triggers; 63Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 64connection master; 65drop table t1; 66drop table t2; 67connection slave; 68include/rpl_end.inc 69