rpl000004.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- set SQL_LOG_BIN=0;
- create table t1 (word char(20) not null, index(word));
- load data infile '../../std_data/words.dat' into table t1;
- create table t2 (word char(20) not null);
- load data infile '../../std_data/words.dat' into table t2;
- create table t3 (word char(20) not null primary key);
- load table t1 from master;
- load table t2 from master;
- load table t3 from master;
- check table t1;
- Table Op Msg_type Msg_text
- test.t1 check status OK
- select count(*) from t2;
- count(*)
- 70
- select count(*) from t3;
- count(*)
- 0
- set SQL_LOG_BIN=1;
- drop table if exists t1,t2,t3;
- create table t1(n int);
- drop table t1;