1stop slave;
2drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3reset master;
4reset slave;
5drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6start slave;
7CREATE TABLE t1 (word CHAR(20) NOT NULL);
8LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
9SELECT * FROM t1 ORDER BY word;
10word
11Aarhus
12Aarhus
13Aaron
14Aaron
15Ababa
16Ababa
17aback
18aback
19abaft
20abaft
21abandon
22abandon
23abandoned
24abandoned
25abandoning
26abandoning
27abandonment
28abandonment
29abandons
30abandons
31abase
32abased
33abasement
34abasements
35abases
36abash
37abashed
38abashes
39abashing
40abasing
41abate
42abated
43abatement
44abatements
45abater
46abates
47abating
48Abba
49abbe
50abbey
51abbeys
52abbot
53abbots
54Abbott
55abbreviate
56abbreviated
57abbreviates
58abbreviating
59abbreviation
60abbreviations
61Abby
62abdomen
63abdomens
64abdominal
65abduct
66abducted
67abduction
68abductions
69abductor
70abductors
71abducts
72Abe
73abed
74Abel
75Abelian
76Abelson
77Aberdeen
78Abernathy
79aberrant
80aberration
81SELECT * FROM t1 ORDER BY word;
82word
83Aarhus
84Aarhus
85Aaron
86Aaron
87Ababa
88Ababa
89aback
90aback
91abaft
92abaft
93abandon
94abandon
95abandoned
96abandoned
97abandoning
98abandoning
99abandonment
100abandonment
101abandons
102abandons
103abase
104abased
105abasement
106abasements
107abases
108abash
109abashed
110abashes
111abashing
112abasing
113abate
114abated
115abatement
116abatements
117abater
118abates
119abating
120Abba
121abbe
122abbey
123abbeys
124abbot
125abbots
126Abbott
127abbreviate
128abbreviated
129abbreviates
130abbreviating
131abbreviation
132abbreviations
133Abby
134abdomen
135abdomens
136abdominal
137abduct
138abducted
139abduction
140abductions
141abductor
142abductors
143abducts
144Abe
145abed
146Abel
147Abelian
148Abelson
149Aberdeen
150Abernathy
151aberrant
152aberration
153drop table t1;
154