The fractional data types : Data Type Summary « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Data Type Summary

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








Related examples in the same category

1. Data Types in MySQL
2.Binary data types support the storage of large amounts of data, such as image and sound files.
3.Numeric Column Types
4.Integer Types in MySQL with Sizes and Ranges