rpl000003.test
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 0k
Category:

MySQL

Development Platform:

Visual C++

  1. source include/master-slave.inc;
  2. connection master;
  3. drop table if exists t1;
  4. create table t1(n int primary key);
  5. !insert into t1 values (1),(2),(2);
  6. insert into t1 values (3);
  7. save_master_pos;
  8. connection slave;
  9. sync_with_master;
  10. @r/rpl000003.result select * from t1;                                     
  11. connection master;
  12. drop table t1;
  13. save_master_pos;
  14. connection slave;
  15. sync_with_master;