SQL

1. INSERT INTO

1.1. INSERT INTO Tabel (veld1, veld2) VALUES ("waarde1", "waarde2");

1.1.1. NULL

2. UPDATE

2.1. UPDATE Tabel SET veld1=“waarde1”, veld2=“waarde2” WHERE veld3="waarde3";

3. DELETE

3.1. DELETE FROM Tabel WHERE veld="waarde";

4. SELECT

4.1. SELECT veld1, veld2 FROM Tabel AS t WHERE veld3="waarde";

4.1.1. DISTINCT

4.1.2. *

4.1.3. =, <, >, <=, >=

4.1.4. LIKE "wa_rde%"

4.1.5. IN ("waarde1", "waarde2")

4.1.6. NOT = "waarde"

4.1.7. AND, OR

5. JOIN

5.1. SELECT * FROM Tabel1 as T1 INNER JOIN Tabel2 as T2 ON T1.veld1 = T2.veld2

5.1.1. INNER JOIN

5.1.2. LEFT JOIN

5.1.3. RIGHT JOIN