My SQL Data Type
-:Data Type:- ================ INT:- A numeric type that can accept values in the range of 2147483648 to -2147483647. DECIMAL:- A numeric type with support for floating point numbers. DATE:- A Date field in the YYYYMMDD format TIME:- A Time field in the HH:MM:SS format DATETIME:- A combined date/time type in the YYYYMMDD HH:MM:SS format. YEAR:- A field specifically for year displays in the range 1901 to 2155,in either YYYY or YY formats. TIMESTAMP:- A timestamp, in YYYYMMDD - HHMMSS formats. CHAR:- A string type with a maximum size of 255 characters and a variable length. VARCHAR:- A string type with a maximum size of 255 characters and a fixed length. TEXT:- A string type with a maximum size of 655