Data Types - Yousef's Notes
Data Types

Data Types

#INTEGER

Used for whole numbers. eg: INT, TINYINT, SMALLINT, BIGINT

#FLOAT and DOUBLE

Used for decimal numbers with floating-point precision. eg: FLOAT, REAL, DOUBLE, DECIMAL, NUMERIC.

#CHAR and VARCHAR

Used for character strings. CHAR has a fixed length, while VARCHAR is variable-length eg: CHAR(10), VARCHAR(255).

#DATE and TIME

Used for date and time values eg: DATE, TIME, DATETIME, TIMESTAMP

#BOOLEAN

Used for true/false values. eg: BOOLEAN, BOOL

#BINARY

Used for binary data, such as images or files. eg: BLOB, BINARY, VARBINARY