<< 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 1:  General Information 55 MySQL Server Add a PRIMARY KEY or UNIQUE key to the table and use this.  New in Version 3.23.11:  If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid. mSQL Use the _rowid column.  Observe that _rowid may change over time depending on many factors. To Get the Time a Column Was Last Modi ed MySQL Server Add a TIMESTAMP column to the table.  This column is automatically set to the current date and time for INSERT or UPDATE statements if you don't give the column a value or if you give it a NULL value. mSQL Use the _timestamp column. NULL  Value Comparisons MySQL Server MySQL Server follows ANSI SQL, and a comparison with NULL is always NULL. mSQL In mSQL, NULL = NULL is TRUE. You must change =NULL to IS NULL and <>NULL to IS NOT NULL when porting old code from mSQL to MySQL Server. String Comparisons MySQL Server Normally, string comparisons are performed in case-independent fashion with the sort order determined by the current character set (ISO-8859-1 Latin1 by default).  If you don't like this, declare your columns with the BINARY attribute, which causes comparisons to be done according to the ASCII order used on the MySQL server host. mSQL All string comparisons are performed in case-sensitive fashion with sorting in ASCII order. Case-insensitive Searching MySQL Server LIKE is a case-insensitive or case-sensitive operator, depending on the columns involved.  If possible, MySQL uses indexes if the LIKE argument doesn't start with a wildcard character. mSQL Use CLIKE. Handling of Trailing Spaces MySQL Server Strips all spaces at the end of CHAR and VARCHAR columns.  Use a TEXT column if this behaviour is not desired. mSQL Retains trailing space. WHERE  Clauses
     

    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