MySQL size and length of each data type

Digital type

Type	Size	Range (signed)	Range (unsigned)	Use
TINYINT	1 bytes	(-128,127)	(0,255)	Small integer value
SMALLINT	2 bytes	(-32 768,32 767)	(0,65 535)	Large integer value
Mediumint	3 bytes	(-8 388 608,8 388 607)	(0,16 777 215)	Large integer value
int or integer	4 bytes	(-2 147 483 648,2 147 483 647)	(0,4 294 967 295)	Large integer value
BIGINT	8 bytes	(-9 233 372 036 854 775 808,9 223 372 036 854 775 807)	(0,18 446 744 073 709 551 615)	Maximum integer value
FLOAT	4 bytes	( -3.402 823 466 e+38,1.175 494 351 E-38), 0, (1.175 494 351 e-38,3.402 823 466 351 e+38)	0, (1.175 494 351 e-38,3.402 823 466 e+38)	Single precision Floating point value
DOUBLE	8 bytes	(1.797 693 134 862 315 7 e+308,2.225 073 858 507 201 4 E-308), 0, (2.225 073 858 507 201 4 e-308,1.797 693 134 862 315 7 e+3 08)	0, (2.225 073 858 507 201 4 e-308,1.797 693 134 862 315 7 e+308)	Double precision Floating point value
DECIMAL	For decimal (m,d), if m>d, is m+2 otherwise d+2	Values that depend on M and D	Values that depend on M and D	Decimal value

Character type

CHAR	0-255 bytes	Fixed length string
VARCHAR	0-255 bytes	Variable length string
Tinyblob	0-255 bytes	A binary string of no more than 255 characters
Tinytext	0-255 bytes	Short text string
Blob	0-65 535 bytes	Long text data in binary form
TEXT	0-65 535 bytes	Long Text data
Mediumblob	0-16 777 215 bytes	Medium-length text data in binary form
Mediumtext	0-16 777 215 bytes	Medium-Length text data
Logngblob	0-4 294 967 295 bytes	Large text data in binary form
Longtext	0-4 294 967 295 bytes	Maximum text data

Enumerate collections

ENUM (maximum of 65,535 members) 64KB
SET (maximum of 64 members) 64KB

Time Type

Type	Size bytes	Range	Format	Use
DATE	3	1000-01-01/9999-12-31	Yyyy-mm-dd	Date value
Time	3	' -838:59:59 '/' 838:59:59 '	HH:MM:SS	Time Value or duration
Year	1	1901/2155	YYYY	Year value
Datetime	8	1000-01-01 00:00:00/9999-12-31 23:59:59	YYYY-MM-DD HH:MM:SS	Blend date and time values
TIMESTAMP	8	1970-01-01 00:00:00/2037, sometime	YYYYMMDD HHMMSS	Mixed date and time values, timestamp

MySQL size and length of each data type