MySQL Data Types
Numeric, types — INT (whole numbers), DECIMAL (PRECISE, financial, values), FLOAT (approximate, decimals). String, types — VARCHAR (VARIABLE-length, text, MAX, size, DEFINE, karна, PADТА, hai), TEXT (LONGER, text, content).
Date/Time, types — DATE, DATETIME, TIMESTAMP — HAR, EK, ki, DIFFERENT, RANGE, aur, USE-CASE, hai. BOOLEAN, (actually, TINYINT(1) internally), true/false, values, ke, liye.
CREATE TABLE products (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
price DECIMAL(10,2),
in_stock BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);- Numeric: INT, DECIMAL (precise), FLOAT (approximate)
- String: VARCHAR (variable-length), TEXT (long content)
- Date/Time: DATE, DATETIME, TIMESTAMP — DIFFERENT, use-cases
ENUM, EK, column, ko, EK, PREDEFINED, list, of, values, tak, RESTRICT, karta hai (jaise, "small", "medium", "large") — SET, similar, hai, LEKIN, MULTIPLE, values, ek, saath, SELECT, karne, deta, hai.
CREATE TABLE products (
size ENUM('small', 'medium', 'large'),
tags SET('sale', 'new', 'featured')
);MySQL 5.7+, mein, EK, native, JSON, data, type, hai — SEMI-STRUCTURED, data, ko, store, karne, ke, liye, USEFUL, hai, JSON_EXTRACT() jaise, functions, se, QUERY, bhi, kiya, ja, sakta, hai, bina, POORA, JSON, PARSE, kiye, application, mein.