This repository contains 2 files:
- SQL file used to create and configure the database
- SQL snippets file to query and alter the db
Query Types
- SELECT / SELECT LIMIT / SELECT DISTINCT
- INSERT
- UPDATE
- Subqueries
- DELETE / DROP
Tables and views
- CREATE / ALTER TABLE
- MODIFY / ADD COLUMN
- DROP TABLE / COLUMN
Clauses
- WHERE
- ORDER BY
- GROUP BY
JOINS
- INNER / OUTTER JOIN
CONDITIONS
- AND / OR
- LIKE