🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

In the previous post, we explored SQL basics and how we interact with databases. But here’s 👇 👉 What kind of data can we actually store in MySQL? That’s where Data Types come in. 🔹 What are Data Types? Data types define what kind of value a column can store . Think of it like rules: Name → text Age → number Date → date Without data types, data would become messy and inconsistent. 🔹 Types of Data in MySQL MySQL mainly supports: 📝 Character (String) types 🔢 Numeric types 📅 Date & Time types 🖼️ Binary / Large Object types 🔹 1. Character (String) Data Types Used to store text values 👇 CHAR(n) Fixed length Faster retrieval Wastes space VARCHAR(n) Variable length Saves space Slightly slower than CHAR 📌 Example use cases: Name Address City 🔹 2. TEXT Data Types Used for large text data TINYTEXT → up to 255 characters TEXT → up to 65,535 characters MEDIUMTEXT → up to 16 MB LONGTEXT → up to 4 GB 💡 Stored outside the table (uses pointer internally) 👉 Used for: Comments Reviews Resume Feedback 🔹 3