rpl000008.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- #this one assumes we are ignoring updates on table foo, but doing
- #the ones on all other tables
- source include/master-slave.inc;
- connection slave;
- use test;
- drop table if exists foo;
- create table foo (n int);
- insert into foo values(4);
- connection master;
- use test;
- drop table if exists foo;
- create table foo (n int);
- insert into foo values(5);
- drop table if exists bar;
- create table bar (m int);
- insert into bar values(15);
- drop table if exists choo;
- create table choo (k int);
- insert into choo values(55);
- save_master_pos;
- connection slave;
- sync_with_master;
- @r/rpl000008.result select foo.n,bar.m,choo.k from foo,bar,choo;
- connection master;
- drop table if exists foo,bar,choo;
- save_master_pos;
- connection slave;
- sync_with_master;
- drop table if exists foo,bar,choo;