Mind Map Gallery SQL
This is a mind map that contains information about 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
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
