1
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
2
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
3
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
4
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
5
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
6
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
7
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
8
SELECT * FROM t1 ORDER BY c1;
13
SELECT * FROM t2 ORDER BY c1;
17
SELECT * FROM t3 ORDER BY c1;
24
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
25
SELECT * FROM t1 ORDER BY c1;
30
SELECT * FROM t2 ORDER BY c1;
34
SELECT * FROM t3 ORDER BY c1;
42
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
43
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
44
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
45
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
46
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
47
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
48
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
49
SELECT * FROM t1 ORDER BY c1;
54
SELECT * FROM t2 ORDER BY c1;
58
SELECT * FROM t3 ORDER BY c1;
65
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
66
SELECT * FROM t1 ORDER BY c1;
71
SELECT * FROM t2 ORDER BY c1;
75
SELECT * FROM t3 ORDER BY c1;
83
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
84
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
85
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
86
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
87
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
88
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
89
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
90
SELECT * FROM t1 ORDER BY c1;
95
SELECT * FROM t2 ORDER BY c1;
99
SELECT * FROM t3 ORDER BY c1;
106
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
107
SELECT * FROM t1 ORDER BY c1;
112
SELECT * FROM t2 ORDER BY c1;
116
SELECT * FROM t3 ORDER BY c1;
124
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
125
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
126
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
127
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
128
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
129
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
130
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
131
SELECT * FROM t1 ORDER BY c1;
136
SELECT * FROM t2 ORDER BY c1;
140
SELECT * FROM t3 ORDER BY c1;
147
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
148
SELECT * FROM t1 ORDER BY c1;
153
SELECT * FROM t2 ORDER BY c1;
157
SELECT * FROM t3 ORDER BY c1;
165
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
166
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
167
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
168
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
169
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
170
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
171
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
172
SELECT * FROM t1 ORDER BY c1;
177
SELECT * FROM t2 ORDER BY c1;
181
SELECT * FROM t3 ORDER BY c1;
188
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
189
SELECT * FROM t1 ORDER BY c1;
194
SELECT * FROM t2 ORDER BY c1;
198
SELECT * FROM t3 ORDER BY c1;
206
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
207
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
208
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
209
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
210
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
211
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
212
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
213
SELECT * FROM t1 ORDER BY c1;
218
SELECT * FROM t2 ORDER BY c1;
222
SELECT * FROM t3 ORDER BY c1;
229
DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
230
SELECT * FROM t1 ORDER BY c1;
235
SELECT * FROM t2 ORDER BY c1;
239
SELECT * FROM t3 ORDER BY c1;
247
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
248
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
249
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
250
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
251
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
252
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
253
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
254
SELECT * FROM t1 ORDER BY c1;
259
SELECT * FROM t2 ORDER BY c1;
263
SELECT * FROM t3 ORDER BY c1;
270
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
271
SELECT * FROM t1 ORDER BY c1;
276
SELECT * FROM t2 ORDER BY c1;
280
SELECT * FROM t3 ORDER BY c1;
288
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
289
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
290
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
291
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
292
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
293
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
294
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
295
SELECT * FROM t1 ORDER BY c1;
300
SELECT * FROM t2 ORDER BY c1;
304
SELECT * FROM t3 ORDER BY c1;
311
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
312
SELECT * FROM t1 ORDER BY c1;
317
SELECT * FROM t2 ORDER BY c1;
321
SELECT * FROM t3 ORDER BY c1;
329
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
330
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
331
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
332
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
333
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
334
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
335
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
336
SELECT * FROM t1 ORDER BY c1;
341
SELECT * FROM t2 ORDER BY c1;
345
SELECT * FROM t3 ORDER BY c1;
352
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
353
SELECT * FROM t1 ORDER BY c1;
358
SELECT * FROM t2 ORDER BY c1;
362
SELECT * FROM t3 ORDER BY c1;
370
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
371
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
372
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
373
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
374
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
375
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
376
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
377
SELECT * FROM t1 ORDER BY c1;
382
SELECT * FROM t2 ORDER BY c1;
386
SELECT * FROM t3 ORDER BY c1;
393
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
394
SELECT * FROM t1 ORDER BY c1;
399
SELECT * FROM t2 ORDER BY c1;
403
SELECT * FROM t3 ORDER BY c1;
411
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
412
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
413
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
414
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
415
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
416
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
417
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
418
SELECT * FROM t1 ORDER BY c1;
423
SELECT * FROM t2 ORDER BY c1;
427
SELECT * FROM t3 ORDER BY c1;
434
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
435
SELECT * FROM t1 ORDER BY c1;
440
SELECT * FROM t2 ORDER BY c1;
444
SELECT * FROM t3 ORDER BY c1;
452
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
453
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
454
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
455
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
456
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
457
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
458
DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
459
SELECT * FROM t1 ORDER BY c1;
464
SELECT * FROM t2 ORDER BY c1;
468
SELECT * FROM t3 ORDER BY c1;
475
DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
476
SELECT * FROM t1 ORDER BY c1;
481
SELECT * FROM t2 ORDER BY c1;
485
SELECT * FROM t3 ORDER BY c1;
493
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
494
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
495
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
496
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
497
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
498
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
499
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
500
SELECT * FROM t1 ORDER BY c1;
505
SELECT * FROM t2 ORDER BY c1;
509
SELECT * FROM t3 ORDER BY c1;
516
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
517
SELECT * FROM t1 ORDER BY c1;
522
SELECT * FROM t2 ORDER BY c1;
526
SELECT * FROM t3 ORDER BY c1;
534
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
535
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
536
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
537
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
538
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
539
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
540
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
541
SELECT * FROM t1 ORDER BY c1;
546
SELECT * FROM t2 ORDER BY c1;
550
SELECT * FROM t3 ORDER BY c1;
557
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
558
SELECT * FROM t1 ORDER BY c1;
563
SELECT * FROM t2 ORDER BY c1;
567
SELECT * FROM t3 ORDER BY c1;
575
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
576
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
577
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
578
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
579
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
580
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
581
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
582
SELECT * FROM t1 ORDER BY c1;
587
SELECT * FROM t2 ORDER BY c1;
591
SELECT * FROM t3 ORDER BY c1;
598
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
599
SELECT * FROM t1 ORDER BY c1;
604
SELECT * FROM t2 ORDER BY c1;
608
SELECT * FROM t3 ORDER BY c1;
616
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
617
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
618
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
619
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
620
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
621
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
622
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
623
SELECT * FROM t1 ORDER BY c1;
628
SELECT * FROM t2 ORDER BY c1;
632
SELECT * FROM t3 ORDER BY c1;
639
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
640
SELECT * FROM t1 ORDER BY c1;
645
SELECT * FROM t2 ORDER BY c1;
649
SELECT * FROM t3 ORDER BY c1;
657
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
658
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
659
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
660
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
661
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
662
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
663
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
664
SELECT * FROM t1 ORDER BY c1;
669
SELECT * FROM t2 ORDER BY c1;
673
SELECT * FROM t3 ORDER BY c1;
680
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
681
SELECT * FROM t1 ORDER BY c1;
686
SELECT * FROM t2 ORDER BY c1;
690
SELECT * FROM t3 ORDER BY c1;
698
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
699
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
700
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
701
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
702
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
703
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
704
DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
705
SELECT * FROM t1 ORDER BY c1;
710
SELECT * FROM t2 ORDER BY c1;
714
SELECT * FROM t3 ORDER BY c1;
721
DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
722
SELECT * FROM t1 ORDER BY c1;
727
SELECT * FROM t2 ORDER BY c1;
731
SELECT * FROM t3 ORDER BY c1;
739
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
740
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
741
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
742
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
743
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
744
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
745
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
746
SELECT * FROM t1 ORDER BY c1;
751
SELECT * FROM t2 ORDER BY c1;
755
SELECT * FROM t3 ORDER BY c1;
762
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
763
SELECT * FROM t1 ORDER BY c1;
768
SELECT * FROM t2 ORDER BY c1;
772
SELECT * FROM t3 ORDER BY c1;
780
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
781
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
782
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
783
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
784
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
785
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
786
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
787
SELECT * FROM t1 ORDER BY c1;
792
SELECT * FROM t2 ORDER BY c1;
796
SELECT * FROM t3 ORDER BY c1;
803
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
804
SELECT * FROM t1 ORDER BY c1;
809
SELECT * FROM t2 ORDER BY c1;
813
SELECT * FROM t3 ORDER BY c1;
821
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
822
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
823
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
824
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
825
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
826
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
827
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
828
SELECT * FROM t1 ORDER BY c1;
833
SELECT * FROM t2 ORDER BY c1;
837
SELECT * FROM t3 ORDER BY c1;
844
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
845
SELECT * FROM t1 ORDER BY c1;
850
SELECT * FROM t2 ORDER BY c1;
854
SELECT * FROM t3 ORDER BY c1;
862
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
863
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
864
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
865
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
866
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
867
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
868
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
869
SELECT * FROM t1 ORDER BY c1;
874
SELECT * FROM t2 ORDER BY c1;
878
SELECT * FROM t3 ORDER BY c1;
885
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
886
SELECT * FROM t1 ORDER BY c1;
891
SELECT * FROM t2 ORDER BY c1;
895
SELECT * FROM t3 ORDER BY c1;
903
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
904
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
905
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
906
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
907
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
908
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
909
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
910
SELECT * FROM t1 ORDER BY c1;
915
SELECT * FROM t2 ORDER BY c1;
919
SELECT * FROM t3 ORDER BY c1;
926
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
927
SELECT * FROM t1 ORDER BY c1;
932
SELECT * FROM t2 ORDER BY c1;
936
SELECT * FROM t3 ORDER BY c1;
944
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
945
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
946
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
947
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
948
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
949
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
950
DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
951
SELECT * FROM t1 ORDER BY c1;
956
SELECT * FROM t2 ORDER BY c1;
960
SELECT * FROM t3 ORDER BY c1;
967
DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
968
SELECT * FROM t1 ORDER BY c1;
973
SELECT * FROM t2 ORDER BY c1;
977
SELECT * FROM t3 ORDER BY c1;