Data Types MySQL Tutorial

Type Name Memory Space
TINYINT1 byte
SMALLINT2 bytes
MEDIUMINT3 bytes
INT4 bytes
BIGINT8 bytes
FLOAT(M,D)4 bytes
DOUBLE(M,D)8 bytes
DECIMAL(M,D)The value of M + 2 bytes