DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) Column types

Info Catalog (mysql.info.gz) Charset (mysql.info.gz) Top (mysql.info.gz) Functions
 
 11 Column Types
 ***************
 

Menu

 
* Column type overview        Column Type Overview
* Numeric types               Numeric Types
* Date and time types         Date and Time Types
* String types                String Types
* Storage requirements        Column Type Storage Requirements
* Choosing types              Choosing the Right Type for a Column
* Other-vendor column types   Using Column Types from Other Database Engines
 
 MySQL supports a number of column types in several categories: numeric
 types, date and time types, and string (character) types.  This chapter
 first gives an overview of these column types, and then provides a more
 detailed description of the properties of the types in each category,
 and a summary of the column type storage requirements.  The overview is
 intentionally brief.  The more detailed descriptions should be
 consulted for additional information about particular column types,
 such as the allowable formats in which you can specify values.
 
 MySQL versions 4.1 and up support extensions for handing spatial data.
 Information about spatial types is provided in  Spatial extensions
 in MySQL.
 
 Several of the column type descriptions use these conventions:
 
 `M'
      Indicates the maximum display width.  The maximum legal display
      width is 255.
 
 `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 parts of type specifiers
      that are optional.
 
 
Info Catalog (mysql.info.gz) Charset (mysql.info.gz) Top (mysql.info.gz) Functions
automatically generated byinfo2html