Spracherkennung für: .test vermutete Sprache: SQL {SQL[220] VDM[88] Lisp[55]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_partition.inc
CREATE TABLE t1 (a INT) PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (1), PARTITION p1 VALUES LESS THAN (MAXVALUE));
INSERT INTO t1 VALUES (1),(2);
ALTER TABLE t1 MODIFY a INT AUTO_INCREMENT PRIMARY KEY;
UPDATE t1 PARTITION (p1) SET a=9 ORDER BY a LIMIT 1;
# Cleanup
DROP TABLE t1;
[Dauer der Verarbeitung: 0.9 Sekunden]
