#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