MySQL Column Types

tinyint -128 +127

smallint -32768 +32767

mediumint -8388608 +8388607

int -2147683648 + 2147683647

bigint -263 +263-1

float (6,2)

double (10,2)

decimal (6,3)

char varchar tinyblob blob mediumblob longblob tinytext text mediumtext longtext enum

set date datetime time timestamp year