<< 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
    6 MySQL Technical Reference for Version 4.0.3    All columns have default values.  You can use INSERT to insert a subset of a table's columns;  those columns that are not explicitly given values are set to their default values. Commands and Functions    Full  operator  and  function  support  in  the  SELECT  and  WHERE  parts  of queries.  For example: mysql> SELECT CONCAT(first_name, " ", last_name) -> FROM tbl_name -> WHERE income/dependents > 10000 AND age > 30;    Full support for SQL  GROUP BY  and  ORDER BY  clauses.  Support for group functions (COUNT(), COUNT(DISTINCT ...), AVG(), STD(), SUM(), MAX(), and MIN()).    Support for LEFT OUTER JOIN and RIGHT OUTER JOIN with ANSI SQL and ODBC syntax.    Aliases on tables and columns are allowed as in the SQL92 standard.    DELETE, INSERT, REPLACE, and UPDATE return the number of rows that were changed (a ected).  It is possible to return the number of rows matched instead by setting a ag when connecting to the server.    The  MySQL-speci c  SHOW  command  can  be  used  to  retrieve  information about databases, tables, and indexes.  The EXPLAIN command can be used to determine how the optimiser resolves a query.    Function names do not clash with table or column names.  For example, ABS is a valid column name.  The only restriction is that for a function call, no spaces are allowed between the function name and the `(' that follows it.  See Section 6.1.7 [Reserved words], page 385.    You can mix tables from di erent databases in the same query (as of Ver- sion 3.22). Security    A privilege and password system that is very exible and secure, and allows host-based veri cation.  Passwords are secure because all password trac is encrypted when you connect to a server. Scalability and Limits    Handles large databases.  We are using MySQL Server with some databases that contain 50 million records and we know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.    Up to 32 indexes per table are allowed.   Each index may consist of 1 to 16 columns or parts of columns.  The maximum index width is 500 bytes (this may be changed when compiling MySQL Server).  An index may use a pre x of a CHAR or VARCHAR  eld. Connectivity    Clients may connect to the MySQL server using TCP/IP Sockets, Unix Sock- ets (Unix), or Named Pipes (NT).
     

    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