SQL
This is a mind map that contains information about SQL.
Tags:
Similar Mind Maps
Outline

SQL

SELECT
SELECT veld1, veld2 FROM Tabel AS t WHERE veld3="waarde";
=, <, >, <=, >=
IN ("waarde1", "waarde2")

JOIN
SELECT * FROM Tabel1 as T1

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");