MySQL Data Types

Q. What is a Data Type in MySQL?

A data type defines the kind of data that a column can store in a table.

For example: When you want to store numbers like age or salary, you use a numeric data type. If you want to store names or addresses, you use a text data type.

Example:

CREATE TABLE Person_tbl (
    id INT,
    name VARCHAR(100),
    age INT,
    is_active BOOLEAN
);

Explanation:

• INT → used for whole numbers
• VARCHAR(100) → used for text (maximum 100 characters)
• BOOLEAN → used for true/false values