Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL (Structured query language - Coggle Diagram
SQL
(Structured query language
Clear and Concise schema
Create Data= Developer
1970
Select
Data
BETWEEN
WHERE field BETWEEN xxx AND yyy;
IN
WHERE IN ('xxx','yyy')
AND,OR
<= , >=
LIKE
(search specific data)
WHERE field LIKE
'x%'( Start with x)
'%x'(End with x)
' = single quote,backtick
SUM
MAX
/
MIN
SELECT MAX (field) FROM table;
ORDER
BY
SELECT 'album' WHERE artist ORDER BY year released;
SELECT * FROM characters ORDER BY name;
SELECT * FROM field WHERE field = '..'
WHERE
COUNT
ID = Auto increment
NESTED Select Data
SELECT artist, released, album FROM table WHERE released = (SELECT MIN (released) FROM table );
Foreign key
Primary key
SELECT = Column we want to pull data
WHERE = table name