1include/master-slave.inc
2[connection master]
3connection master;
4DROP TABLE IF EXISTS test.t1;
5CREATE TABLE test.t1 (a VARCHAR(255), PRIMARY KEY(a));
6LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
7DELETE FROM test.t1 WHERE a = 'abashed';
8DELETE FROM test.t1;
9LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
10SELECT * FROM test.t1 ORDER BY a DESC;
11a
12aberration
13aberrant
14Abernathy
15Aberdeen
16Abelson
17Abelian
18Abel
19abed
20Abe
21abducts
22abductors
23abductor
24abductions
25abduction
26abducted
27abduct
28abdominal
29abdomens
30abdomen
31Abby
32abbreviations
33abbreviation
34abbreviating
35abbreviates
36abbreviated
37abbreviate
38Abbott
39abbots
40abbot
41abbeys
42abbey
43abbe
44Abba
45abating
46abates
47abater
48abatements
49abatement
50abated
51abate
52abasing
53abashing
54abashes
55abashed
56abash
57abases
58abasements
59abasement
60abased
61abase
62connection slave;
63connection slave;
64SELECT * FROM test.t1 ORDER BY a DESC;
65a
66aberration
67aberrant
68Abernathy
69Aberdeen
70Abelson
71Abelian
72Abel
73abed
74Abe
75abducts
76abductors
77abductor
78abductions
79abduction
80abducted
81abduct
82abdominal
83abdomens
84abdomen
85Abby
86abbreviations
87abbreviation
88abbreviating
89abbreviates
90abbreviated
91abbreviate
92Abbott
93abbots
94abbot
95abbeys
96abbey
97abbe
98Abba
99abating
100abates
101abater
102abatements
103abatement
104abated
105abate
106abasing
107abashing
108abashes
109abashed
110abash
111abases
112abasements
113abasement
114abased
115abase
116connection master;
117DROP TABLE test.t1;
118connection slave;
119include/rpl_end.inc
120