MySQL

#Data Type in mySQL

Data Type	Description	Use Case
CHAR	String (0-255), can store characters of fixed length	CHAR(50)
VARCHAR	String (0-255), can store characters up to given length	VARCHAR(50)
BLOB	String (0-65535), can store characters up to given length	VARCHAR(50)
INT	Integer (-2, 147, 483 to 2, 147, 483, 647)	INT
TINYINT	Integer (-128 to 127)	TINYINT
BIGINT	Integer (-9, 223, 372, 036, 854, 775, 808 to 9, 223, 372, 036, 854, 775, 807)	BIGINT
BIT	Can store x-bit values x can range from 1 to 64	BIT(2)
FLOAT	Decimal number -with precision to 23 digits	FLOAT
DOUBLE	Decimal number -with precision to 24 to 53 digits	DOUBLE
BOOLEAN	Boolean values 0 or 1	BOOLEAN
DATE	Date in format of YYYY-MM--DD ranging from 1000-01-01 to 9999-12-31	DATE
YEAR	Year in 4 digits format ranging from 1901 to 2155	YEAR