<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 6:  MySQL Language Reference 387 STARTING STRAIGHT_JOIN STRIPED TABLE TABLES TERMINATED THEN TINYBLOB TINYINT TINYTEXT TO TRAILING UNION UNIQUE UNLOCK UNSIGNED UPDATE USAGE USE USER_RESOURCES USING VALUES VARBINARY VARCHAR VARYING WHEN WHERE WITH WRITE XOR YEAR_MONTH ZEROFILL The  following  symbols  (from  the  table  above)  are  disallowed  by  ANSI  SQL  but  allowed by MySQL as column/table names.  This is because some of these names are very natural names and a lot of people have already used them.    ACTION    BIT    DATE    ENUM    NO    TEXT    TIME    TIMESTAMP 6.2  Column Types MySQL supports a number of column types, which may be grouped into three categories: numeric types, date and time types, and string (character) types.  This section rst gives an overview of the types available and summarises the storage requirements for each col- umn type, then provides a more detailed description of the properties of the types in each category.   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. The column types supported by MySQL are listed below.  The following code letters are used in the descriptions: M Indicates the maximum display size.  The maximum legal display size is 255. D Applies to oating-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 speci ers that are optional. Note  that  if  you  specify  ZEROFILL  for  a  column,  MySQL  will  automatically  add  the UNSIGNED  attribute to the column.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide