(mysql.info) data-types

 
 11 Data Types
 *************

 
* data-type-overview           Data Type Overview
* numeric-types                Numeric Types
* date-and-time-types          Date and Time Types
* string-types                 String Types
* storage-requirements         Data Type Storage Requirements
* choosing-types               Choosing the Right Type for a Column
* other-vendor-data-types      Using Data Types from Other Database Engines
 
 MySQL supports a number of data types in several categories: numeric
 types, date and time types, and string (character) types. This chapter
 first gives an overview of these data types, and then provides a more
 detailed description of the properties of the types in each category,
 and a summary of the data type storage requirements. The initial
 overview is intentionally brief. The more detailed descriptions later
 in the chapter should be consulted for additional information about
 particular data types, such as the allowable formats in which you can
 specify values.
 
 MySQL also supports extensions for handing spatial data.  
 spatial-extensions, provides information about these data types.
 
 Several of the data type descriptions use these conventions:
 
    * `M' indicates the maximum display width for integer types. For
      floating-point and fixed-point types, M is the total number of
      digits. For string types, M is the maximum length. The maximum
      allowable value of M depends on the data type.
 
    * `D' applies to floating-point and fixed-point types and indicates
      the number of digits following the decimal point. The maximum
      possible value is 30, but should be no greater than M-2.
 
    * Square brackets (‘`['’ and ‘`]'’) indicate optional parts
      of type definitions.

Info Catalog

(mysql.info) charset

(mysql.info) Top

(mysql.info) functions

automatically generated byinfo2html

(mysql.info) data-types

Menu