1
DROP DATABASE IF EXISTS d1;
2
DROP DATABASE IF EXISTS d2;
3
DROP DATABASE IF EXISTS d3;
7
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
8
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
9
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
10
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
11
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
12
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
13
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;
14
SELECT * FROM d1.t1 ORDER BY c1;
19
SELECT * FROM d2.t2 ORDER BY c1;
23
SELECT * FROM d3.t3 ORDER BY c1;
30
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;
31
SELECT * FROM d1.t1 ORDER BY c1;
36
SELECT * FROM d2.t2 ORDER BY c1;
40
SELECT * FROM d3.t3 ORDER BY c1;
53
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
54
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
55
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
56
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
57
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
58
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
59
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;
60
SELECT * FROM d1.t1 ORDER BY c1;
65
SELECT * FROM d2.t2 ORDER BY c1;
69
SELECT * FROM d3.t3 ORDER BY c1;
76
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;
77
SELECT * FROM d1.t1 ORDER BY c1;
82
SELECT * FROM d2.t2 ORDER BY c1;
86
SELECT * FROM d3.t3 ORDER BY c1;
99
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
100
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
101
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
102
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
103
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
104
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
105
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;
106
SELECT * FROM d1.t1 ORDER BY c1;
111
SELECT * FROM d2.t2 ORDER BY c1;
115
SELECT * FROM d3.t3 ORDER BY c1;
122
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;
123
SELECT * FROM d1.t1 ORDER BY c1;
128
SELECT * FROM d2.t2 ORDER BY c1;
132
SELECT * FROM d3.t3 ORDER BY c1;
145
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
146
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
147
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
148
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
149
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
150
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
151
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;
152
SELECT * FROM d1.t1 ORDER BY c1;
157
SELECT * FROM d2.t2 ORDER BY c1;
161
SELECT * FROM d3.t3 ORDER BY c1;
168
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;
169
SELECT * FROM d1.t1 ORDER BY c1;
174
SELECT * FROM d2.t2 ORDER BY c1;
178
SELECT * FROM d3.t3 ORDER BY c1;
191
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
192
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
193
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
194
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
195
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
196
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
197
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;
198
SELECT * FROM d1.t1 ORDER BY c1;
203
SELECT * FROM d2.t2 ORDER BY c1;
207
SELECT * FROM d3.t3 ORDER BY c1;
214
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;
215
SELECT * FROM d1.t1 ORDER BY c1;
220
SELECT * FROM d2.t2 ORDER BY c1;
224
SELECT * FROM d3.t3 ORDER BY c1;
237
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
238
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
239
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
240
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
241
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
242
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
243
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;
244
SELECT * FROM d1.t1 ORDER BY c1;
249
SELECT * FROM d2.t2 ORDER BY c1;
253
SELECT * FROM d3.t3 ORDER BY c1;
260
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;
261
SELECT * FROM d1.t1 ORDER BY c1;
266
SELECT * FROM d2.t2 ORDER BY c1;
270
SELECT * FROM d3.t3 ORDER BY c1;
283
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
284
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
285
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
286
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
287
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
288
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
289
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;
290
SELECT * FROM d1.t1 ORDER BY c1;
295
SELECT * FROM d2.t2 ORDER BY c1;
299
SELECT * FROM d3.t3 ORDER BY c1;
306
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;
307
SELECT * FROM d1.t1 ORDER BY c1;
312
SELECT * FROM d2.t2 ORDER BY c1;
316
SELECT * FROM d3.t3 ORDER BY c1;
329
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
330
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
331
CREATE TABLE d3.t3 (c1 SMALLINT 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 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;
336
SELECT * FROM d1.t1 ORDER BY c1;
341
SELECT * FROM d2.t2 ORDER BY c1;
345
SELECT * FROM d3.t3 ORDER BY c1;
352
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;
353
SELECT * FROM d1.t1 ORDER BY c1;
358
SELECT * FROM d2.t2 ORDER BY c1;
362
SELECT * FROM d3.t3 ORDER BY c1;
375
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
376
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
377
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
378
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
379
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
380
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
381
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;
382
SELECT * FROM d1.t1 ORDER BY c1;
387
SELECT * FROM d2.t2 ORDER BY c1;
391
SELECT * FROM d3.t3 ORDER BY c1;
398
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;
399
SELECT * FROM d1.t1 ORDER BY c1;
404
SELECT * FROM d2.t2 ORDER BY c1;
408
SELECT * FROM d3.t3 ORDER BY c1;
421
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
422
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
423
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
424
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
425
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
426
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
427
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;
428
SELECT * FROM d1.t1 ORDER BY c1;
433
SELECT * FROM d2.t2 ORDER BY c1;
437
SELECT * FROM d3.t3 ORDER BY c1;
444
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;
445
SELECT * FROM d1.t1 ORDER BY c1;
450
SELECT * FROM d2.t2 ORDER BY c1;
454
SELECT * FROM d3.t3 ORDER BY c1;
467
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
468
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
469
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
470
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
471
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
472
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
473
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;
474
SELECT * FROM d1.t1 ORDER BY c1;
479
SELECT * FROM d2.t2 ORDER BY c1;
483
SELECT * FROM d3.t3 ORDER BY c1;
490
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;
491
SELECT * FROM d1.t1 ORDER BY c1;
496
SELECT * FROM d2.t2 ORDER BY c1;
500
SELECT * FROM d3.t3 ORDER BY c1;
513
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
514
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
515
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
516
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
517
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
518
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
519
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;
520
SELECT * FROM d1.t1 ORDER BY c1;
525
SELECT * FROM d2.t2 ORDER BY c1;
529
SELECT * FROM d3.t3 ORDER BY c1;
536
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;
537
SELECT * FROM d1.t1 ORDER BY c1;
542
SELECT * FROM d2.t2 ORDER BY c1;
546
SELECT * FROM d3.t3 ORDER BY c1;
559
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
560
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
561
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
562
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
563
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
564
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
565
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;
566
SELECT * FROM d1.t1 ORDER BY c1;
571
SELECT * FROM d2.t2 ORDER BY c1;
575
SELECT * FROM d3.t3 ORDER BY c1;
582
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;
583
SELECT * FROM d1.t1 ORDER BY c1;
588
SELECT * FROM d2.t2 ORDER BY c1;
592
SELECT * FROM d3.t3 ORDER BY c1;
605
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
606
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
607
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
608
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
609
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
610
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
611
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;
612
SELECT * FROM d1.t1 ORDER BY c1;
617
SELECT * FROM d2.t2 ORDER BY c1;
621
SELECT * FROM d3.t3 ORDER BY c1;
628
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;
629
SELECT * FROM d1.t1 ORDER BY c1;
634
SELECT * FROM d2.t2 ORDER BY c1;
638
SELECT * FROM d3.t3 ORDER BY c1;
651
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
652
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
653
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
654
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
655
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
656
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
657
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;
658
SELECT * FROM d1.t1 ORDER BY c1;
663
SELECT * FROM d2.t2 ORDER BY c1;
667
SELECT * FROM d3.t3 ORDER BY c1;
674
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;
675
SELECT * FROM d1.t1 ORDER BY c1;
680
SELECT * FROM d2.t2 ORDER BY c1;
684
SELECT * FROM d3.t3 ORDER BY c1;
697
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
698
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
699
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
700
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
701
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
702
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
703
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;
704
SELECT * FROM d1.t1 ORDER BY c1;
709
SELECT * FROM d2.t2 ORDER BY c1;
713
SELECT * FROM d3.t3 ORDER BY c1;
720
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;
721
SELECT * FROM d1.t1 ORDER BY c1;
726
SELECT * FROM d2.t2 ORDER BY c1;
730
SELECT * FROM d3.t3 ORDER BY c1;
743
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
744
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
745
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
746
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
747
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
748
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
749
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;
750
SELECT * FROM d1.t1 ORDER BY c1;
755
SELECT * FROM d2.t2 ORDER BY c1;
759
SELECT * FROM d3.t3 ORDER BY c1;
766
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;
767
SELECT * FROM d1.t1 ORDER BY c1;
772
SELECT * FROM d2.t2 ORDER BY c1;
776
SELECT * FROM d3.t3 ORDER BY c1;
789
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
790
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
791
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
792
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
793
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
794
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
795
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;
796
SELECT * FROM d1.t1 ORDER BY c1;
801
SELECT * FROM d2.t2 ORDER BY c1;
805
SELECT * FROM d3.t3 ORDER BY c1;
812
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;
813
SELECT * FROM d1.t1 ORDER BY c1;
818
SELECT * FROM d2.t2 ORDER BY c1;
822
SELECT * FROM d3.t3 ORDER BY c1;
835
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
836
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
837
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
838
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
839
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
840
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
841
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;
842
SELECT * FROM d1.t1 ORDER BY c1;
847
SELECT * FROM d2.t2 ORDER BY c1;
851
SELECT * FROM d3.t3 ORDER BY c1;
858
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;
859
SELECT * FROM d1.t1 ORDER BY c1;
864
SELECT * FROM d2.t2 ORDER BY c1;
868
SELECT * FROM d3.t3 ORDER BY c1;
881
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
882
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
883
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
884
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
885
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
886
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
887
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;
888
SELECT * FROM d1.t1 ORDER BY c1;
893
SELECT * FROM d2.t2 ORDER BY c1;
897
SELECT * FROM d3.t3 ORDER BY c1;
904
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;
905
SELECT * FROM d1.t1 ORDER BY c1;
910
SELECT * FROM d2.t2 ORDER BY c1;
914
SELECT * FROM d3.t3 ORDER BY c1;
927
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
928
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
929
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
930
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
931
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
932
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
933
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;
934
SELECT * FROM d1.t1 ORDER BY c1;
939
SELECT * FROM d2.t2 ORDER BY c1;
943
SELECT * FROM d3.t3 ORDER BY c1;
950
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;
951
SELECT * FROM d1.t1 ORDER BY c1;
956
SELECT * FROM d2.t2 ORDER BY c1;
960
SELECT * FROM d3.t3 ORDER BY c1;
973
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
974
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
975
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
976
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
977
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
978
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
979
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;
980
SELECT * FROM d1.t1 ORDER BY c1;
985
SELECT * FROM d2.t2 ORDER BY c1;
989
SELECT * FROM d3.t3 ORDER BY c1;
996
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;
997
SELECT * FROM d1.t1 ORDER BY c1;
1002
SELECT * FROM d2.t2 ORDER BY c1;
1006
SELECT * FROM d3.t3 ORDER BY c1;
1019
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1020
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1021
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1022
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
1023
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
1024
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
1025
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;
1026
SELECT * FROM d1.t1 ORDER BY c1;
1031
SELECT * FROM d2.t2 ORDER BY c1;
1035
SELECT * FROM d3.t3 ORDER BY c1;
1042
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;
1043
SELECT * FROM d1.t1 ORDER BY c1;
1048
SELECT * FROM d2.t2 ORDER BY c1;
1052
SELECT * FROM d3.t3 ORDER BY c1;
1065
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1066
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1067
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
1068
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
1069
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
1070
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
1071
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;
1072
SELECT * FROM d1.t1 ORDER BY c1;
1077
SELECT * FROM d2.t2 ORDER BY c1;
1081
SELECT * FROM d3.t3 ORDER BY c1;
1088
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;
1089
SELECT * FROM d1.t1 ORDER BY c1;
1094
SELECT * FROM d2.t2 ORDER BY c1;
1098
SELECT * FROM d3.t3 ORDER BY c1;