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                        65535 characters.

BLOB:- A binary type for variables date.

ENUM:-   A string type that can accept one value                  from a list of previously defined                                 possible values.

SET:-  A string type that can accept zero or more              values from a set of previously defined                    possible values.