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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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 FROM d1.t1, d2.t2 USING 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 FROM d1.t1, d2.t2, d3.t3 USING 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;