In the previous post, I talked about RDBMS and how it solves the limitations of traditional DBMS.
But today, let’s step into the real-world tool that developers actually use 👇
👉 MySQL
MySQL is an open-source Relational Database Management System (RDBMS) that helps us store, manage, and retrieve structured data efficiently.
It was launched in 1995 by a Swedish company.
The name comes from:
- “My” → daughter of the co-founder
- “SQL” → Structured Query Language
👉 In simple words:
MySQL = A system that stores data in tables and lets you interact using SQL.
🔹 Why MySQL?
- ✔️ Free & Open Source
- ✔️ Fast and Efficient
- ✔️ Secure (authentication + permissions)
- ✔️ Supports multiple users
- ✔️ Used in real-world applications
- ✔️ Less programming required
🔹 What makes it powerful?
👉 It uses SQL (Structured Query Language)
With SQL, you can:
- Create databases and tables
- Insert and update data
- Delete records
- Fetch data using queries
🔹 Tools developers use with MySQL
- 🖥️ MySQL Workbench → GUI for writing queries
- ⌨️ Command Line Client → direct interaction
- 🔗 Connectors → Java, Python, etc.
- ⚙️ MySQL PL → functions & procedures
- 📊 MySQL for Excel → data handling in sheets
- 🔔 MySQL Notifier → alerts & status
- 💾 MySQL Enterprise Backup → backup & recovery
- 📈 MySQL Enterprise Manager → monitoring & performance
🔹 Types of SQL Commands
📌 SQL is divided into 4 main categories:
- 🧱 DDL (Data Definition Language)
→ Create, Drop, Alter
- ✏️ DML (Data Manipulation Language)
→ Insert, Update, Delete
- 🔐 DCL (Data Control Language)
→ Grant, Revoke
- 🔍 DQL (Data Query Language)
→ Select
🔹 Extra (Advanced Concepts)
⚡ TCL / DTL (Transaction Control Language)
→ Commit, Rollback, Savepoint⚡ Additional commands
→ Rename, Truncate
🔹 Naming Rules (Important)
- Oracle → Max 30 characters
MySQL → Max 64 characters
Allowed → A–Z, a–z, 0–9
Must start with a letter
Special characters like
$,#allowed
💡 In MySQL, reserved characters (like #) can be used with backticks
👉 In the next post, we’ll dive into MySQL Data Types 🚀
Top comments (0)