mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
68 lines
2.3 KiB
Text
68 lines
2.3 KiB
Text
include/master-slave.inc
|
|
[connection master]
|
|
drop table if exists t11;
|
|
connection slave;
|
|
drop table if exists t11;
|
|
create table t2 (n int);
|
|
insert into t2 values(4);
|
|
connection master;
|
|
create table t2 (s char(20));
|
|
load data infile '../../std_data/words.dat' into table t2;
|
|
insert into t2 values('five');
|
|
create table t1 (m int);
|
|
insert into t1 values(15),(16),(17);
|
|
update t1 set m=20 where m=16;
|
|
delete from t1 where m=17;
|
|
create table t11 select * from t1;
|
|
connection slave;
|
|
select * from t1 ORDER BY m;
|
|
m
|
|
15
|
|
20
|
|
select * from t2;
|
|
n
|
|
4
|
|
select * from t11;
|
|
ERROR 42S02: Table 'test.t11' doesn't exist
|
|
connection master;
|
|
drop table if exists t1,t2,t11;
|
|
connection slave;
|
|
Replicate_Do_Table = 'test.t1'
|
|
connection master;
|
|
create table t1 (a int, b int);
|
|
create trigger trg1 before insert on t1 for each row set new.b=2;
|
|
create table t2 (a int, b int);
|
|
create trigger trg2 before insert on t2 for each row set new.b=2;
|
|
show tables;
|
|
Tables_in_test
|
|
t1
|
|
t2
|
|
show triggers;
|
|
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
|
|
trg1 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 utf8mb4_uca1400_ai_ci
|
|
trg2 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 utf8mb4_uca1400_ai_ci
|
|
connection slave;
|
|
connection slave;
|
|
show tables;
|
|
Tables_in_test
|
|
t1
|
|
show triggers;
|
|
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
|
|
trg1 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 utf8mb4_uca1400_ai_ci
|
|
connection master;
|
|
drop trigger trg1;
|
|
drop trigger trg2;
|
|
show triggers;
|
|
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
|
|
connection slave;
|
|
connection slave;
|
|
show tables;
|
|
Tables_in_test
|
|
t1
|
|
show triggers;
|
|
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
|
|
connection master;
|
|
drop table t1;
|
|
drop table t2;
|
|
connection slave;
|
|
include/rpl_end.inc
|