SQL

SQL
SELECT
SELECT veld1, veld2
FROM Tabel AS t
WHERE veld3="waarde";
DISTINCT
*
=, <, >, <=, >=
LIKE "wa_rde%"
IN ("waarde1", "waarde2")
NOT = "waarde"
AND, OR
JOIN
SELECT * FROM Tabel1 as T1
INNER JOIN Tabel2 as T2
ON T1.veld1 = T2.veld2
INNER JOIN
LEFT JOIN
RIGHT JOIN
INSERT INTO
INSERT INTO Tabel (veld1, veld2)
VALUES ("waarde1", "waarde2");
NULL
UPDATE
UPDATE Tabel
SET veld1=“waarde1”, veld2=“waarde2”
WHERE veld3="waarde3";
DELETE
DELETE FROM Tabel
WHERE veld="waarde";
101