MindMap Gallery SQL
This is a mind map that contains information about SQL.
This is a mind map about 3-step Writing Process Business.
This is a mind map about advertising 2.
This is a mind map about SBAR. Let's see!
40k classes
Cisco IOS interface
application development and deployment
Data Sanitization Tools
DATA COLLECTION MEASURES
Android
Java Training
Active reading techniques
Classification of visual languages
Game Theory
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