SQL

Basic SQL-code

Get Started. It's Free
or sign up with your email address
Rocket clouds
SQL by Mind Map: SQL

1. SELECT

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

1.1.1. DISTINCT

1.1.2. *

1.1.3. =, <, >, <=, >=

1.1.4. LIKE "wa_rde%"

1.1.5. IN ("waarde1", "waarde2")

1.1.6. NOT = "waarde"

1.1.7. AND, OR

2. INSERT INTO

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

2.1.1. NULL

3. UPDATE

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

4. DELETE

4.1. DELETE FROM Tabel WHERE veld="waarde";

5. JOIN

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

5.1.1. INNER JOIN

5.1.2. LEFT JOIN

5.1.3. RIGHT JOIN