Spracherkennung für: .test vermutete Sprache: SQL {SQL[208] VDM[72] Lisp[58]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_partition.inc
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT);
INSERT INTO t1 VALUES (1,10),(2,20);
CREATE TABLE t2 (b INT) PARTITION BY KEY (b) PARTITIONS 2;
INSERT INTO t2 VALUES (1),(2);
DELETE t2 FROM t2 WHERE b BETWEEN 5 AND 9;
UPDATE t2 JOIN t1 SET b = 5;
DROP TABLE t1, t2;
[Dauer der Verarbeitung: 0.11 Sekunden, vorverarbeitet 2026-10-11]
