Apache Derby - Syntax

In diesem Kapitel finden Sie die Syntax aller Apache Derby SQL-Anweisungen.

Alle Anweisungen beginnen mit einem der Schlüsselwörter wie SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW und alle Anweisungen enden mit einem Semikolon (;).

Die SQL-Anweisungen von Apache Derby beziehen sich auf sensible Elemente einschließlich Tabellennamen.

CREATE-Anweisung

CREATE TABLE table_name (
   column_name1 column_data_type1 constraint (optional),
   column_name2 column_data_type2 constraint (optional),
   column_name3 column_data_type3 constraint (optional)
);

TROPFENTABELLE

DROP TABLE table_name;

INSERT-Anweisung

INSERT INTO table_name VALUES (column_name1, column_name2, ...);

SELECT-Anweisung

SELECT column_name, column_name, ... FROM table_name;

UPDATE-Anweisung

UPDATE table_name
   SET column_name = value, column_name = value, ...
   WHERE conditions;

DELETE-Anweisung

DELETE FROM table_name WHERE condition;

DESCRIBE-Anweisung

Describe table_name

SQL TRUNCATE TABLE-Anweisung

TRUNCATE TABLE table_name;

ALTER-Anweisung - Spalte hinzufügen

ALTER TABLE table_name ADD COLUMN column_name column_type;

ALTER-Anweisung - Hinzufügen einer Einschränkung

ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint (column_name);

ALTER-Anweisung - Spalte löschen

ALTER TABLE table_name DROP COLUMN column_name;

ALTER-Anweisung - Einschränkung löschen

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

WO-Klausel

SELECT * from table_name WHERE condition;
or,
DELETE from table_name WHERE condition;
or,
UPDATE table_name SET column_name = value WHERE condition;

GROUP BY-Klausel

SELECT column1, column2, . . . table_name GROUP BY column1, column2, . . .;

ORDER BY-Klausel

SELECT * FROM table_name ORDER BY column_name ASC|DESC.

Klausel haben

SELECT column1, column2 . . . from table_name GROUP BY column having
condition;

Index erstellen

CTREATE INDEX index_name on table_name (column_name);

Erstellen eines EINZIGARTIGEN Index

CREATE UNIQUE INDEX index_name on table_name (column_name);

Erstellen eines COMPOSITE-Index

CREATE INDEX index_name on table_name (column_name1, column_name2);

Anzeigen der Indizes

SHOW INDEXES FROM table_name;

Indizes löschen

DROP INDEX index_name;