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