Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
-
-
-
SQL Commands
SQL Database
-
-
STATEMENTS
SELECT
-
SELECT column_1, column_2 … FROM table_name;
-
INSERT INTO
All columns
INSERT INTO table_name VALUES (value_1, value_2);
Specified columns
INSERT INTO table_name (column_1, column_2) VALUES (value_1, value_2);
-
-
CLAUSES
WHERE
SELECT column_1, column_2 FROM table_name WHERE condition;
-
-
-
JOINS
KEYWORD
-
-
RIGHT JOIN
Returns all the records from the right table (table 2) and matching ones from the left table (table 1)
-
-
-
-