Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Syntax
SELECT
SELECT column 1 , column 2 / * FROM table;
-
-
WHERE
SELECT column , column FROM table WHERE column = "Some value" AND column >= "Some value"
-
-
ORDER BY
SELECT column 1 , column 2 FROM table ORDER BY column 1 , column 2 / ASC / DESC
-
-
-
-
-
-
-
JOINS
-
-
LEFT OUTER JOIN
SELECT * FROM table1
LEFT OUTER JOIN table2 ON table1.column_match = table2.column_match WHERE table2.column IS null
UNION
SELECT col1 , col2
FROM tbl1
UNION
SELECT col1 , col2
FROM tbl2
Self join
SELECT COL , COL , COL ,COL, FROM TABLE AS TA , TABLE AS T2 ; WHERE T1.COL = T2.COL
-
-
-
Subqueries
SELECT Col , col , Col FROM table WHERE col > ( SELECT AVG (col) FROM table )
Keys
Primary key
CREATE Table
( colname : datatype PRIMARY KEY,
colname datatype)
-
INSERT INTO table (col1 , col2....)
VALUES (value1 , value2 ..)
INSERT INTO table (col1 , col2....)
VALUES (value1 , value2 ..)
(Multiple values) (value1 , value2..)
UPDATE table
SET col1 = val1,
col2 = val2, WHERE cond
-
-
-
-
-