What are the SQL Data Types?
.png)
1. Numeric Data Types
- INT: Integer data type. Examples:
INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT.
- FLOAT: Single-precision floating point number. Example:
FLOAT.
- DOUBLE: Double-precision floating point number. Example:
DOUBLE.
- DECIMAL: Exact numeric data type with fixed precision and scale. Example:
DECIMAL(10, 2).
2. String Data Types
- CHAR: Fixed-length character string. Example:
CHAR(10).
- VARCHAR: Variable-length character string. Example:
VARCHAR(255).
- TEXT: Large text data. Example:
TEXT, MEDIUMTEXT, LONGTEXT.
3. Date and Time Data Types
- DATE: Date values (YYYY-MM-DD).
- DATETIME: Date and time values (YYYY-MM-DD HH:MM).
- TIMESTAMP: Timestamp values (YYYY-MM-DD HH:MM), often used for tracking changes.