MySQL Tutorial — One-Page Cheat Sheet
The world's most popular open-source database.
MySQL Tutorial
- HOME
- Intro
- Install / mysql CLI
- Data Types
- CREATE DATABASE
- CREATE TABLE
- SELECT
- INSERT
- UPDATE
- DELETE
- JOINs
- GROUP BY
- ORDER BY / LIMIT
MySQL Features
- AUTO_INCREMENT
- JSON Functions
- WITH (CTEs)
- Window Functions
- FULLTEXT Search
- Generated Columns
- Partitioning
Performance & Ops
- Indexes
- EXPLAIN
- Transactions / Isolation
- InnoDB Internals
- Users & Privileges
- mysqldump / Restore
- Replication