MySQL HowTo

1. Databases and tables
2. Inserting data
3. Principles of CRUD in MySQL using CREATE, SELECT, UPDATE and DELETE
4. Common string functions using CONCAT, SUBSTRING, REPLACE, REVERSE, CHAR_LENGTH, UPPER and LOWER
5. More refined searching using DISTINCT, ORDER BY, LIMIT, WHERE and LIKE
6. In-built calculations using COUNT, GROUP BY, MIN, MAX, SUM and AVG
7. More data types with CHAR, DECIMAL, FLOAT, DOUBLE, DATE, TIME, DATETIME, CURDATE, CURTIME, CURDATETIME, NOW(), TIMESTAMP and CURRENT_TIMESTAMP
8. More operators using !=, NOT LIKE, >, >=, <, <=, AND, &&, OR, ||, BETWEEN, NOT BETWEEN, IN, NOT IN, % and CASE
9. One-to-many JOINs with cross JOINs, INNER JOIN, LEFT JOIN, RIGHT JOIN and ON DELETE CASCADE
10. Many-to-many JOINs
11. Triggers in MySQL

The landing page to the GitHub Pages version of this repo is here.