<< 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
    54 MySQL Technical Reference for Version 4.0.3 1.9.1.3  How mSQL 2.0 SQL Syntax Di ers from MySQL Column types MySQL Server Has  the  following  additional  types  (among  others;  see  Section  6.5.3  [CREATE TABLE], page 469):    ENUM type for one of a set of strings.    SET type for many of a set of strings.    BIGINT type for 64-bit integers. MySQL Server also supports the following additional type attributes:    UNSIGNED option for integer and oating-point columns.    ZEROFILL option for integer columns.    AUTO_INCREMENT  option for integer columns that are a  PRIMARY KEY.  See Section 8.4.3.30 [mysql_insert_id()], page 580.    DEFAULT value for all columns. mSQL2 mSQL  column  types  correspond  to  the  MySQL  types  shown  in  the  following table: mSQL  type Corresponding MySQL type CHAR(len) CHAR(len) TEXT(len) TEXT(len).  len is the maximal length.  And LIKE works. INT INT.  With many more options! REAL REAL.  Or  FLOAT.  Both 4- and 8-byte versions are available. UINT INT UNSIGNED DATE DATE.  Uses ANSI SQL format rather than mSQL's own format. TIME TIME MONEY DECIMAL(12,2).  A xed-point value with two decimals. Index Creation MySQL Server Indexes may be speci ed at table creation time with the CREATE TABLE state- ment. mSQL Indexes must be created after the table has been created, with separate CREATE INDEX statements. To Insert a Unique Identi er into a Table MySQL Server Use AUTO_INCREMENT as a column type speci er.  See Section 8.4.3.30 [mysql_ insert_id()], page 580. mSQL Create a SEQUENCE on a table and select the _seq column. To Obtain a Unique Identi er for a Row
     

    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