1reset master;
2drop table if exists t1,t2;
3create table t1 (word varchar(20)) -- create table t1;
4create table t2 (word varchar(20)) -- create table t2;
5load data infile '../../std_data/words.dat' into table t1 -- load data to t1;
6insert into t2 values ("Ada");
7flush logs;
8select * from t2;
9word
10Ada
11flush logs;
12select * from t2;
13word
14Ada
15drop table t1,t2;
16