2
DROP DATABASE IF EXISTS d1;
3
DROP DATABASE IF EXISTS d2;
4
DROP DATABASE IF EXISTS d3;
9
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
10
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
11
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
12
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
13
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
14
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
15
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
16
SELECT * FROM d1.t1 ORDER BY c1;
17
SELECT * FROM d2.t2 ORDER BY c1;
18
SELECT * FROM d3.t3 ORDER BY c1;
19
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
20
SELECT * FROM d1.t1 ORDER BY c1;
21
SELECT * FROM d2.t2 ORDER BY c1;
22
SELECT * FROM d3.t3 ORDER BY c1;
29
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
30
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
31
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
32
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
33
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
34
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
35
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
36
SELECT * FROM d1.t1 ORDER BY c1;
37
SELECT * FROM d2.t2 ORDER BY c1;
38
SELECT * FROM d3.t3 ORDER BY c1;
39
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
40
SELECT * FROM d1.t1 ORDER BY c1;
41
SELECT * FROM d2.t2 ORDER BY c1;
42
SELECT * FROM d3.t3 ORDER BY c1;
49
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
50
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
51
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
52
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
53
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
54
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
55
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
56
SELECT * FROM d1.t1 ORDER BY c1;
57
SELECT * FROM d2.t2 ORDER BY c1;
58
SELECT * FROM d3.t3 ORDER BY c1;
59
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
60
SELECT * FROM d1.t1 ORDER BY c1;
61
SELECT * FROM d2.t2 ORDER BY c1;
62
SELECT * FROM d3.t3 ORDER BY c1;
69
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
70
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
71
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
72
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
73
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
74
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
75
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
76
SELECT * FROM d1.t1 ORDER BY c1;
77
SELECT * FROM d2.t2 ORDER BY c1;
78
SELECT * FROM d3.t3 ORDER BY c1;
79
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
80
SELECT * FROM d1.t1 ORDER BY c1;
81
SELECT * FROM d2.t2 ORDER BY c1;
82
SELECT * FROM d3.t3 ORDER BY c1;
89
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
90
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
91
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
92
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
93
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
94
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
95
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
96
SELECT * FROM d1.t1 ORDER BY c1;
97
SELECT * FROM d2.t2 ORDER BY c1;
98
SELECT * FROM d3.t3 ORDER BY c1;
99
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
100
SELECT * FROM d1.t1 ORDER BY c1;
101
SELECT * FROM d2.t2 ORDER BY c1;
102
SELECT * FROM d3.t3 ORDER BY c1;
109
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
110
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
111
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
112
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
113
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
114
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
115
DELETE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
116
SELECT * FROM d1.t1 ORDER BY c1;
117
SELECT * FROM d2.t2 ORDER BY c1;
118
SELECT * FROM d3.t3 ORDER BY c1;
119
DELETE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
120
SELECT * FROM d1.t1 ORDER BY c1;
121
SELECT * FROM d2.t2 ORDER BY c1;
122
SELECT * FROM d3.t3 ORDER BY c1;
129
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
130
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
131
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
132
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
133
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
134
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
135
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
136
SELECT * FROM d1.t1 ORDER BY c1;
137
SELECT * FROM d2.t2 ORDER BY c1;
138
SELECT * FROM d3.t3 ORDER BY c1;
139
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
140
SELECT * FROM d1.t1 ORDER BY c1;
141
SELECT * FROM d2.t2 ORDER BY c1;
142
SELECT * FROM d3.t3 ORDER BY c1;
149
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
150
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
151
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
152
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
153
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
154
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
155
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
156
SELECT * FROM d1.t1 ORDER BY c1;
157
SELECT * FROM d2.t2 ORDER BY c1;
158
SELECT * FROM d3.t3 ORDER BY c1;
159
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
160
SELECT * FROM d1.t1 ORDER BY c1;
161
SELECT * FROM d2.t2 ORDER BY c1;
162
SELECT * FROM d3.t3 ORDER BY c1;
169
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
170
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
171
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
172
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
173
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
174
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
175
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
176
SELECT * FROM d1.t1 ORDER BY c1;
177
SELECT * FROM d2.t2 ORDER BY c1;
178
SELECT * FROM d3.t3 ORDER BY c1;
179
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
180
SELECT * FROM d1.t1 ORDER BY c1;
181
SELECT * FROM d2.t2 ORDER BY c1;
182
SELECT * FROM d3.t3 ORDER BY c1;
189
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
190
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
191
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
192
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
193
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
194
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
195
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
196
SELECT * FROM d1.t1 ORDER BY c1;
197
SELECT * FROM d2.t2 ORDER BY c1;
198
SELECT * FROM d3.t3 ORDER BY c1;
199
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
200
SELECT * FROM d1.t1 ORDER BY c1;
201
SELECT * FROM d2.t2 ORDER BY c1;
202
SELECT * FROM d3.t3 ORDER BY c1;
209
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
210
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
211
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
212
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
213
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
214
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
215
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
216
SELECT * FROM d1.t1 ORDER BY c1;
217
SELECT * FROM d2.t2 ORDER BY c1;
218
SELECT * FROM d3.t3 ORDER BY c1;
219
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
220
SELECT * FROM d1.t1 ORDER BY c1;
221
SELECT * FROM d2.t2 ORDER BY c1;
222
SELECT * FROM d3.t3 ORDER BY c1;
229
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
230
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
231
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
232
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
233
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
234
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
235
DELETE QUICK d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
236
SELECT * FROM d1.t1 ORDER BY c1;
237
SELECT * FROM d2.t2 ORDER BY c1;
238
SELECT * FROM d3.t3 ORDER BY c1;
239
DELETE QUICK d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
240
SELECT * FROM d1.t1 ORDER BY c1;
241
SELECT * FROM d2.t2 ORDER BY c1;
242
SELECT * FROM d3.t3 ORDER BY c1;
249
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
250
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
251
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
252
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
253
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
254
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
255
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
256
SELECT * FROM d1.t1 ORDER BY c1;
257
SELECT * FROM d2.t2 ORDER BY c1;
258
SELECT * FROM d3.t3 ORDER BY c1;
259
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
260
SELECT * FROM d1.t1 ORDER BY c1;
261
SELECT * FROM d2.t2 ORDER BY c1;
262
SELECT * FROM d3.t3 ORDER BY c1;
269
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
270
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
271
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
272
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
273
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
274
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
275
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
276
SELECT * FROM d1.t1 ORDER BY c1;
277
SELECT * FROM d2.t2 ORDER BY c1;
278
SELECT * FROM d3.t3 ORDER BY c1;
279
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
280
SELECT * FROM d1.t1 ORDER BY c1;
281
SELECT * FROM d2.t2 ORDER BY c1;
282
SELECT * FROM d3.t3 ORDER BY c1;
289
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
290
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
291
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
292
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
293
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
294
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
295
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
296
SELECT * FROM d1.t1 ORDER BY c1;
297
SELECT * FROM d2.t2 ORDER BY c1;
298
SELECT * FROM d3.t3 ORDER BY c1;
299
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
300
SELECT * FROM d1.t1 ORDER BY c1;
301
SELECT * FROM d2.t2 ORDER BY c1;
302
SELECT * FROM d3.t3 ORDER BY c1;
309
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
310
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
311
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
312
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
313
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
314
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
315
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
316
SELECT * FROM d1.t1 ORDER BY c1;
317
SELECT * FROM d2.t2 ORDER BY c1;
318
SELECT * FROM d3.t3 ORDER BY c1;
319
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
320
SELECT * FROM d1.t1 ORDER BY c1;
321
SELECT * FROM d2.t2 ORDER BY c1;
322
SELECT * FROM d3.t3 ORDER BY c1;
329
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
330
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
331
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
332
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
333
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
334
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
335
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
336
SELECT * FROM d1.t1 ORDER BY c1;
337
SELECT * FROM d2.t2 ORDER BY c1;
338
SELECT * FROM d3.t3 ORDER BY c1;
339
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
340
SELECT * FROM d1.t1 ORDER BY c1;
341
SELECT * FROM d2.t2 ORDER BY c1;
342
SELECT * FROM d3.t3 ORDER BY c1;
349
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
350
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
351
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
352
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
353
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
354
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
355
DELETE IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
356
SELECT * FROM d1.t1 ORDER BY c1;
357
SELECT * FROM d2.t2 ORDER BY c1;
358
SELECT * FROM d3.t3 ORDER BY c1;
359
DELETE IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
360
SELECT * FROM d1.t1 ORDER BY c1;
361
SELECT * FROM d2.t2 ORDER BY c1;
362
SELECT * FROM d3.t3 ORDER BY c1;
369
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
370
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
371
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
372
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
373
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
374
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
375
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
376
SELECT * FROM d1.t1 ORDER BY c1;
377
SELECT * FROM d2.t2 ORDER BY c1;
378
SELECT * FROM d3.t3 ORDER BY c1;
379
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
380
SELECT * FROM d1.t1 ORDER BY c1;
381
SELECT * FROM d2.t2 ORDER BY c1;
382
SELECT * FROM d3.t3 ORDER BY c1;
389
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
390
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
391
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
392
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
393
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
394
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
395
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
396
SELECT * FROM d1.t1 ORDER BY c1;
397
SELECT * FROM d2.t2 ORDER BY c1;
398
SELECT * FROM d3.t3 ORDER BY c1;
399
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
400
SELECT * FROM d1.t1 ORDER BY c1;
401
SELECT * FROM d2.t2 ORDER BY c1;
402
SELECT * FROM d3.t3 ORDER BY c1;
409
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
410
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
411
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
412
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
413
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
414
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
415
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
416
SELECT * FROM d1.t1 ORDER BY c1;
417
SELECT * FROM d2.t2 ORDER BY c1;
418
SELECT * FROM d3.t3 ORDER BY c1;
419
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
420
SELECT * FROM d1.t1 ORDER BY c1;
421
SELECT * FROM d2.t2 ORDER BY c1;
422
SELECT * FROM d3.t3 ORDER BY c1;
429
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
430
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
431
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
432
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
433
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
434
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
435
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
436
SELECT * FROM d1.t1 ORDER BY c1;
437
SELECT * FROM d2.t2 ORDER BY c1;
438
SELECT * FROM d3.t3 ORDER BY c1;
439
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
440
SELECT * FROM d1.t1 ORDER BY c1;
441
SELECT * FROM d2.t2 ORDER BY c1;
442
SELECT * FROM d3.t3 ORDER BY c1;
449
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
450
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
451
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
452
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
453
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
454
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
455
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
456
SELECT * FROM d1.t1 ORDER BY c1;
457
SELECT * FROM d2.t2 ORDER BY c1;
458
SELECT * FROM d3.t3 ORDER BY c1;
459
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
460
SELECT * FROM d1.t1 ORDER BY c1;
461
SELECT * FROM d2.t2 ORDER BY c1;
462
SELECT * FROM d3.t3 ORDER BY c1;
469
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
470
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
471
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
472
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
473
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
474
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
475
DELETE QUICK IGNORE d1.t1, d2.t2 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
476
SELECT * FROM d1.t1 ORDER BY c1;
477
SELECT * FROM d2.t2 ORDER BY c1;
478
SELECT * FROM d3.t3 ORDER BY c1;
479
DELETE QUICK IGNORE d1.t1.*, d2.t2.*, d3.t3 FROM d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
480
SELECT * FROM d1.t1 ORDER BY c1;
481
SELECT * FROM d2.t2 ORDER BY c1;
482
SELECT * FROM d3.t3 ORDER BY c1;