MySQL Introduction MySQL Installation MySQL Workbench Create Database Drop Database Show Databases Select Database Create Table Drop Table Alter Table Show Tables Describe Table Truncate Table Data Types Overview Numeric Types String Types Date & Time Types NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY DEFAULT CHECK AUTO_INCREMENT Indexes INSERT INTO SELECT UPDATE DELETE WHERE Clause AND, OR, NOT ORDER BY LIMIT LIKE & Wildcards IN BETWEEN IS NULL / IS NOT NULL DISTINCT Aliases (AS) MIN & MAX COUNT SUM AVG GROUP BY HAVING Joins Intro INNER JOIN LEFT JOIN RIGHT JOIN CROSS JOIN Self Join UNION Subqueries EXISTS ANY & ALL CASE String Functions Numeric Functions Date Functions IF & IFNULL Views Stored Procedures Stored Functions Transactions Intro COMMIT & ROLLBACK Users & Privileges Backup & Restore