Basic MySQL Topics
- Section 1. Querying data
- SELECT FROM
- SELECT
- Section 2. Sorting data
- ORDER BY
- Section 3. Filtering data
- WHERE
- SELECT DISTINCT
- AND
- OR
- IN
- NOT IN
- BETWEEN
- LIKE
- LIMIT
- IS NULL
- Section 4. Joining tables
- Table & Column Aliases
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CROSS JOIN
- SELF-JOIN
- Section 5. Grouping data
- GROUP BY
- HAVING
- ROLLUP
- Section 6. Subqueries
- Subquery
- Derived table
- EXISTS
- Section 7. Common Table Expressions
- Common Table Expression or CTE
- Recursive CTE
- Section 8. Set operators
- UNION and UNION ALL
- INTERSECT
- MINUS
- Section 9. Modifying data in MySQL
- INSERT
- INSERT Multiple Rows
- INSERT IGNORE
- UPDATE
- UPDATE JOIN
- DELETE
- ON DELETE CASCADE
- DELETE JOIN
- REPLACE
- Prepared Statement
- Section 10. MySQL transaction
- Transaction
- Table Locking
- Section 11. Managing databases
- Selecting a MySQL database
- CREATE DATABASE
- DROP DATABASE
- Section 12. Working with tables
- MySQL storage engines
- CREATE TABLE
- AUTO_INCREMENT
- ALTER TABLE
- Renaming tables
- Removing a column from a table
- Adding a new column to a table
- DROP TABLE
- Temporary tables
- TRUNCATE TABLE
- Generated columns
- Section 13. MySQL data types
- MySQL data types
- DECIMAL
- BIT
- BOOLEAN
- CHAR
- VARCHAR
- TEXT
- DATE
- TIME
- DATETIME
- TIMESTAMP
- JSON
- ENUM
- Section 14. MySQL constraints
- NOT NULL
- Primary key
- Foreign key
- Disable foreign key checks
- UNIQUE constraint
- CHECK constraint
- DEFAULT
- CHECK constraint emulation
- Section 15. MySQL globalization
- Character Set
- Collation
- Section 16. MySQL import & export CSV
- Import CSV File Into MySQL Table
- Export MySQL Table to CSV
- Section 17. Advanced techniques
- Natural sorting