MySQL
The world most popular database
100% free · no signup to
read 6 chapters Database
Created
1995 by MySQL AB (now Oracle)
Type
Relational database management system
Current version
MySQL 8.0 (2023)
Powers
WordPress, Facebook, Twitter, YouTube
Market share
Most popular open-source database
Storage engines
InnoDB (default), MyISAM
License
GPL (community) / Commercial
Best for
Web apps, CMS, read-heavy workloads
What is MySQL?
MySQL is the world's most popular open-source relational database. Created in 1995, it's the database behind WordPress, Facebook, Twitter, and YouTube.
Why MySQL?
MySQL is fast, reliable, and everywhere. If you're building a web app with PHP, WordPress, or a LAMP stack, MySQL is the default database.
| Feature | MySQL | PostgreSQL | SQLite |
|---|---|---|---|
| Speed (reads) | Very fast | Fast | Fast |
| Ease of use | Easy | Medium | Easiest |
| Features | Good | Excellent | Basic |
| Best for | Web apps, CMS | Complex queries | Embedded/mobile |
What you'll learn
| Chapter | What you'll know |
|---|---|
| Introduction | What MySQL is, how to connect |
| Basics | CREATE, SELECT, INSERT, UPDATE, DELETE |
| Joins | Combining tables |
| Indexes | Performance tuning |
Start with introduction.