1
by brian
clean slate |
1 |
create table t1 (a int); |
2 |
insert into t1 values (1); |
|
3 |
insert into t1 values (2); |
|
4 |
insert into t1 values (3); |
|
5 |
update t1 set a=a+2 where a=2; |
|
6 |
update t1 set a=a+2 where a=3; |
|
7 |
create table t2 (word varchar(20)); |
|
8 |
load data infile '../std_data_ln/words.dat' into table t2; |
|
9 |
flush logs; |
|
10 |
drop table t1; |
|
11 |
drop table t2; |
|
12 |
select * from t1; |
|
13 |
a
|
|
14 |
1
|
|
15 |
4
|
|
16 |
5
|
|
17 |
select * from t2; |
|
18 |
word
|
|
19 |
Aarhus
|
|
20 |
Aaron
|
|
21 |
Ababa
|
|
22 |
aback
|
|
23 |
abaft
|
|
24 |
abandon
|
|
25 |
abandoned
|
|
26 |
abandoning
|
|
27 |
abandonment
|
|
28 |
abandons
|
|
29 |
Aarhus
|
|
30 |
Aaron
|
|
31 |
Ababa
|
|
32 |
aback
|
|
33 |
abaft
|
|
34 |
abandon
|
|
35 |
abandoned
|
|
36 |
abandoning
|
|
37 |
abandonment
|
|
38 |
abandons
|
|
39 |
abase
|
|
40 |
abased
|
|
41 |
abasement
|
|
42 |
abasements
|
|
43 |
abases
|
|
44 |
abash
|
|
45 |
abashed
|
|
46 |
abashes
|
|
47 |
abashing
|
|
48 |
abasing
|
|
49 |
abate
|
|
50 |
abated
|
|
51 |
abatement
|
|
52 |
abatements
|
|
53 |
abater
|
|
54 |
abates
|
|
55 |
abating
|
|
56 |
Abba
|
|
57 |
abbe
|
|
58 |
abbey
|
|
59 |
abbeys
|
|
60 |
abbot
|
|
61 |
abbots
|
|
62 |
Abbott
|
|
63 |
abbreviate
|
|
64 |
abbreviated
|
|
65 |
abbreviates
|
|
66 |
abbreviating
|
|
67 |
abbreviation
|
|
68 |
abbreviations
|
|
69 |
Abby
|
|
70 |
abdomen
|
|
71 |
abdomens
|
|
72 |
abdominal
|
|
73 |
abduct
|
|
74 |
abducted
|
|
75 |
abduction
|
|
76 |
abductions
|
|
77 |
abductor
|
|
78 |
abductors
|
|
79 |
abducts
|
|
80 |
Abe
|
|
81 |
abed
|
|
82 |
Abel
|
|
83 |
Abelian
|
|
84 |
Abelson
|
|
85 |
Aberdeen
|
|
86 |
Abernathy
|
|
87 |
aberrant
|
|
88 |
aberration
|
|
89 |
flush logs; |
|
90 |
drop table t2; |
|
91 |
create table t2 (word varchar(20)); |
|
92 |
load data infile '../std_data_ln/words.dat' into table t2; |
|
93 |
insert into t2 select * from t2; |
|
94 |
insert into t2 select * from t2; |
|
95 |
insert into t2 select * from t2; |
|
96 |
insert into t2 select * from t2; |
|
97 |
insert into t2 select * from t2; |
|
98 |
insert into t2 select * from t2; |
|
99 |
insert into t2 select * from t2; |
|
100 |
insert into t2 select * from t2; |
|
101 |
insert into t2 select * from t2; |
|
102 |
select count(*) from t2; |
|
103 |
count(*) |
|
104 |
35840
|
|
105 |
flush logs; |
|
106 |
select count(*) from t2; |
|
107 |
count(*) |
|
108 |
35840
|
|
109 |
drop table t1; |
|
110 |
drop table t2; |