Mega Code Archive

 

Categories / MySQL / Data Type

 

The fractional data types

Data type                  Description FLOAT                      An approximate numeric data type that uses 4 bytes of storage.                             The data type supports the following values: -3.402823466E+38 to -1.175494351E-38                            0                            1.175494351E-38 to 3.402823466E+38 DOUBLE                     An approximate numeric data type that uses 8 bytes of storage.                             The data type supports the following values:                            -1.7976931348623157E+308 to -2.2250738585072014E-308                            0                            2.2250738585072014E-308 to 1.7976931348623157E+308 DOUBLE PRECISION           Synonym for the DOUBLE data type REAL                       Synonym for the DOUBLE data type DECIMAL                    An exact numeric data type whose range storage requirements depend                            on the <length> and <decimals> values specified in the column                            definition DEC                        Synonym for the DECIMAL data type NUMERIC                    Synonym for the DECIMAL data type FIXED                      Synonym for the DECIMAL data type