There are four main groups of data types in MySQL. Each of those groups has more than one type or sub-type to choose from and they are all listed below:

Here is the list of data types and sub-types that MySQL recognizes:

Numeric data types
DIVISION TYPES
Integers INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT, SERIAL
Fixed points DECIMAL, NUMERIC
Floating points FLOAT, DOUBLE
Bit values BIT

String data types
DIVISION TYPES
Strings CHAR, VARCHAR, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET

Date and time data types
DIVISION TYPES
Dates and times TIME, DATE, TIMESTAMP, YEAR

Spatial data types
DIVISION TYPES
Spatial data GEOMETRY, POINT, LINESTRING, POLYGON, GEOMETRYCOLLECTION, MULTILINESTRING, MULTIPOINT, MULTIPOLYGON