README.md

🗄️ MySQL Master Vault

A comprehensive knowledge base for MySQL, optimized for Obsidian.

This repository serves as my "Second Brain" for MySQL. The notes are stored in a dedicated vault folder for better organization.

---

🏗️ Vault Structure

Category	Description	Key Topics
DDL	Data Definition	Schemas, Tables, Altering structures
DML	Data Manipulation	Adding, Updating, and Deleting data
DQL	Data Querying	Complex SELECTs, Joins, and Filtering

---

📚 Table of Contents

🛠️ DDL (Definition)

• CREATE DB & TABLE
• ALTER TABLE
• Constraints
• DROP & RENAME

✍️ DML & DQL (Manipulation & Query)

• INSERT | UPDATE | DELETE
• SELECT | JOINs | WHERE

⚙️ Admin & Functions

• TCL Commands
• BACKUP
• Functions

---

🖼️ Visual References

📁 View Photos Directory

---

🚀 Getting Started

1. Clone the Repository: git clone https://github.com/AhmadHasSwag/mysql-knowledge-base.git
2. Open in Obsidian:
   • Open Obsidian App.
   • Click "Open folder as vault".
   • Important: Select the MySQL-Vault folder specifically.
3. Graph View:
   • Use the Graph View inside Obsidian to see how topics interlink!

   • 📸 Preview

---

Created with ❤️ by Ahmad