SELECT
FROM
JOIN
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT & OFFSET
SELECT Syntax
SELECT [DISTINCT] column1, column2
FROM table_name
FROM table_name
WHERE Operators
=, !=, <, >, <=, >=
LIKE, IN, BETWEEN
IS NULL, IS NOT NULL
LIKE, IN, BETWEEN
IS NULL, IS NOT NULL
JOIN Types
INNER: matching records only
LEFT: all from left table
RIGHT: all from right table
FULL OUTER: all records
LEFT: all from left table
RIGHT: all from right table
FULL OUTER: all records
Aggregate Functions
COUNT(), SUM(), AVG()
MAX(), MIN(), GROUP_CONCAT()
MAX(), MIN(), GROUP_CONCAT()
INSERT Syntax
INSERT INTO table
(col1, col2)
VALUES (val1, val2)
(col1, col2)
VALUES (val1, val2)
UPDATE Syntax
UPDATE table
SET col1 = val1
WHERE condition
SET col1 = val1
WHERE condition
SQL Output
SELECT *
FROM table_name
FROM table_name
Query History
No queries yet