SQL Schnellreferenz

Von CodeW3C.com stammende SQL-Schnellreferenz. Sie kann gedruckt werden, um für den täglichen Gebrauch zur Verfügung zu stehen.

SQL-Anweisung

Anweisung Grammatik
UND / ODER SELECT Spaltenname(s)
FROM Tabellenname
WHERE Bedingung
AND|OR condition
ALTER TABLE (add column) ALTER TABLE table_name
ADD column_name datatype
ALTER TABLE (drop column) ALTER TABLE table_name
DROP COLUMN column_name
AS (alias for column) SELECT column_name AS column_alias
FROM Tabellenname
AS (alias for table) SELECT column_name
FROM table_name AS table_alias
BETWEEN SELECT Spaltenname(s)
FROM Tabellenname
WHERE Spaltenname
BETWEEN value1 AND value2
CREATE DATABASE CREATE DATABASE database_name
CREATE INDEX CREATE INDEX index_name
ON table_name (column_name)
CREATE TABLE CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)
CREATE UNIQUE INDEX CREATE UNIQUE INDEX index_name
ON table_name (column_name)
CREATE VIEW CREATE VIEW view_name AS
SELECT Spaltenname(s)
FROM Tabellenname
WHERE Bedingung
DELETE FROM DELETE FROM table_name
(Hinweis: Löscht das gesamte Table!!)

oder

DELETE FROM table_name
WHERE Bedingung
DROP DATABASE DROP DATABASE database_name
DROP INDEX DROP INDEX table_name.index_name
DROP TABLE DROP TABLE table_name
GROUP BY SELECT Spaltenname1,SUM(Spaltenname2)
FROM Tabellenname
GROUP BY Spaltenname1
HAVING SELECT Spaltenname1,SUM(Spaltenname2)
FROM Tabellenname
GROUP BY Spaltenname1
HAVING SUM(Spaltenname2) Bedingung Wert
IN SELECT Spaltenname(s)
FROM Tabellenname
WHERE Spaltenname
IN (value1,value2,..)
INSERT INTO INSERT INTO Tabellenname
Werte (value1, value2,....)

oder

INSERT INTO Tabellenname
(Spaltenname1, Spaltenname2,...)
Werte (value1, value2,....)
LIKE SELECT Spaltenname(s)
FROM Tabellenname
WHERE Spaltenname
LIKE Muster
ORDER BY SELECT Spaltenname(s)
FROM Tabellenname
ORDER BY Spaltenname [ASC|DESC]
SELECT SELECT Spaltenname(s)
FROM Tabellenname
SELECT * SELECT *
FROM Tabellenname
SELECT DISTINCT SELECT DISTINCT Spaltenname(s)
FROM Tabellenname
SELECT INTO
(wird verwendet, um Sicherungskopien zu erstellen Tabellen)		 SELECT *
IN neue Tabellenname
FROM ursprünglicher Tabellenname

oder

SELECT Spaltenname(s)
IN neue Tabellenname
FROM ursprünglicher Tabellenname
TRUNCATE TABLE
(löscht nur die Daten innerhalb die Tabelle)		 TRUNCATE TABLE Tabellenname
UPDATE UPDATE Tabellenname
SET Spaltenname=new_value
[, Spaltenname=new_value]
WHERE Spaltenname=some_value
WHERE SELECT Spaltenname(s)
FROM Tabellenname
WHERE Bedingung