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