Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL, SQL Execution Order, SQL Commands Order, MySQL Data types, Please…
SQL
DML (Data Manipulation Language)
Retrieving
Conditional Operators
AND, OR
IS, IS NOT
IS NULL, IS NOT NULL
LIKE
IN(), NOT IN()
BETWEEN
=, !=, <>, >, <. >=, <=
Aggregate Functions
MIN(), MAX()
COUNT()
SUM(), AVG()
Joining Statements
JOIN (INNER JOIN)
LEFT/RIGHT JOIN
OUTER JOIN
CROSS JOIN
Sorting Statement
ORDER BY
String Functions
UPPER(), LOWER()
Unioning Statements
UNION
UNION ALL
Retrieving Statements
SELECT
SELECT DISTINCT
Grouping Statement
GROUP BY
Conditional Functions
CASE
Limiting Statement
LIMIT
Alias
AS
Arithmetical Operators
+, -, *, /, %
Filtering Statements
WHERE
HAVING
Inserting
INSERT
Updating
UPDATE
Deleting
DELETE
DDL (Data Definition Language)
Creating
CREATE
Modifying
ALTER
Data Deleting
DELETE
TRUNCATE
Tables Deleting
DROP
DCL (Data Control Language)
Granting access
GRANT
Withdrawing access
REVOKE
TCL (Transactional Control Language)
Saving
COMMIT
SAVE TRANSACTION
Restoring
ROLLBACK
SQL Execution Order
SELECT
FROM (JOIN)
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
DISTINCT
SQL Commands Order
SELECT
FROM (JOIN)
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
MySQL Data types
Numeric
INT
DECIMAL
SMALLINT
FLOAT
BIT
DOUBLE
TINYINT
Character/String
CHAR
TINYTEXT
TEXT
VARCHAR
Date/Time
TIMESTAMP
DATE
TIME
DATETIME
Binary
BOOLEAN
BOOL
Please note that the mindmap is contioniously updated. Current version: 2.0.2 ©
AA
for
ProductStar