Browse all

SELECT WHERE DISTINCT ORDER BY LIMIT OFFSET LIKE BETWEEN IS NULL AND / OR

COUNT SUM AVG MAX MIN GROUP BY HAVING COUNT DISTINCT GROUP_CONCAT

INNER JOIN LEFT JOIN CROSS JOIN SELF JOIN FULL OUTER JOIN

CASE WHEN IFNULL COALESCE NULLIF CAST

CONCAT SUBSTRING TRIM

DATEDIFF DATE_ADD DATE_FORMAT TIMESTAMPDIFF

IN EXISTS

UNION UNION ALL

ROW_NUMBER RANK DENSE_RANK LAG

WITH RECURSIVE CTE

INSERT INTO UPDATE DELETE

EXPLAIN

BEGIN COMMIT ROLLBACK