Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/Firefox/third_party/rust/foldhash/src/ (Firefox Browser Version 153.0.1^©) Datei vom 27.6.2026 mit Größe 9 kB

Quelle de_multi_table.result Sprache: Lisp

CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
SELECT * FROM t1 ORDER BY c1;
c1 c2
3 3
4 4
5 5
SELECT * FROM t2 ORDER BY c1;
c1 c2
12 1
15 6
SELECT * FROM t3 ORDER BY c1;
c1 c2
21 11
22 11
23 13
24 14
25 15
DROP TABLE t1,t2,t3;

Messung V0.5 in Prozent

¤ Dauer der Verarbeitung: 0.19 Sekunden (vorverarbeitet am 2026-10-08) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.