Why Column data types (INT, VARCHAR, DATE, DECIMAL) in SQL? - Purpose & Use Cases

The Big Idea

What if your data could organize itself perfectly and never get mixed up?

The Scenario

Imagine you have a huge notebook where you write down all your friends' information: their age, names, birthdays, and how much money they owe you. You just scribble everything without any order or rules.

The Problem

Without rules, your notebook becomes messy. You might write a name as a number or a birthday as random letters. It's hard to find or trust the info, and mistakes happen often.

The Solution

Using column data types is like giving each notebook column a clear label and rule: ages must be numbers, names must be words, birthdays must be dates, and money must have decimals. This keeps your data neat, correct, and easy to use.

Before vs After

✗ Before

CREATE TABLE friends (age, name, birthday, debt);

✓ After

CREATE TABLE friends (age INT, name VARCHAR(50), birthday DATE, debt DECIMAL(10,2));

What It Enables

It lets databases store and check data correctly, making searching, sorting, and calculating fast and reliable.

Real Life Example

A store uses data types to keep track of product prices (DECIMAL), product names (VARCHAR), stock counts (INT), and expiration dates (DATE) so everything is accurate and easy to manage.

Key Takeaways

Data types give clear rules for each kind of data.

They prevent errors by ensuring data fits the right format.

This makes data easy to organize, search, and calculate.