SQL | Mind Map - EdrawMind

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

DELETE

DELETE FROM Tabel WHERE veld="waarde";

UPDATE

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

INSERT INTO

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

NULL