mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
26 lines
702 B
Plaintext
26 lines
702 B
Plaintext
include/master-slave.inc
|
|
[connection master]
|
|
connection slave;
|
|
use test;
|
|
drop table if exists mysqltest_foo;
|
|
drop table if exists mysqltest_bar;
|
|
create table mysqltest_foo (n int);
|
|
insert into mysqltest_foo values(4);
|
|
connection master;
|
|
use test;
|
|
create table mysqltest_foo (n int);
|
|
insert into mysqltest_foo values(5);
|
|
create table mysqltest_bar (m int);
|
|
insert into mysqltest_bar values(15);
|
|
create table t1 (k int);
|
|
insert into t1 values(55);
|
|
connection slave;
|
|
select mysqltest_foo.n,mysqltest_bar.m,t1.k from mysqltest_foo,mysqltest_bar,t1;
|
|
n m k
|
|
4 15 55
|
|
connection master;
|
|
drop table mysqltest_foo,mysqltest_bar,t1;
|
|
connection slave;
|
|
drop table mysqltest_foo,mysqltest_bar,t1;
|
|
include/rpl_end.inc
|