Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

SQL by Mind Map: SQL
0.0 stars - 0 reviews range from 0 to 5

SQL

SELECT

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

DISTINCT

*

=, <, >, <=, >=

LIKE "wa_rde%"

IN ("waarde1", "waarde2")

NOT = "waarde"

AND, OR

INSERT INTO

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

NULL

UPDATE

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

DELETE

DELETE FROM Tabel WHERE veld="waarde";

JOIN

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

INNER JOIN

LEFT JOIN

RIGHT JOIN