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;