Datatype supported by mysql

mysql datatypes are mainly divided into 3 different types:

string
number
date & time

string datatypes

char
varchar
text
blob  (binary large object ) : To store files, images, videos etc..
tinytext : store range upto 255 characters
tinyblob
longtext : can store upto 214cr bytes.
longblob

numeric datatypes :

tinyint   (-128 to 127)
smallint (signed -32768 to 32767)
mediumint (-8388608 to 8388607)
int    (-247483648 to 8388607)  if unsigned range is 0 to 4294967295
bigint
float
double
decimal

Date and time :
date
datetime
timestamp
time