<< 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
    376 MySQL Technical Reference for Version 4.0.3 6  MySQL Language Reference MySQL has a very complex, but intuitive and easy to learn SQL interface.  This chapter describes the various commands, types, and functions you will need to know in order to use MySQL eciently and e ectively.  This chapter also serves as a reference to all functionality included in MySQL. In order to use this chapter e ectively, you may nd it useful to refer to the various indexes. 6.1  Language Structure 6.1.1  Literals:  How to Write Strings and Numbers This section describes the various ways to write strings and numbers in MySQL. It also covers the various nuances and \gotchas" that you may run into when dealing with these basic types in MySQL. 6.1.1.1  Strings A string is a sequence of characters, surrounded by either single quote (`'') or double quote (`"') characters (only the single quote if you run in ANSI mode).  Examples: 'a string' "another string" Within a string, certain sequences have special meaning.  Each of these sequences begins with  a  backslash  (`\'),  known  as  the  escape  character.   MySQL  recognises  the  following escape sequences: \0 An ASCII 0 (NUL) character. \' A single quote (`'') character. \" A double quote (`"') character. \b A backspace character. \n A newline character. \r A carriage return character. \t A tab character. \z ASCII(26)  (Control-Z).  This  character  can  be  encoded  to  allow  you  to  work around  the  problem  that  ASCII(26)  stands  for  END-OF-FILE  on  Windows. (ASCII(26) will cause problems if you try to use mysql database < filename.) \\ A backslash (`\') character.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    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