<< 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

    48 MySQL Technical Reference for Version 4.0.3    Change the format of DATETIME to store fractions of seconds.    Add all missing ANSI92 and ODBC 3.0 types.    Change table names from empty strings to NULL for calculated columns.    Don't use  Item_copy_string  on numerical values to avoid number->string->number conversion in case of:  SELECT COUNT(*)*(id+0) FROM table_name GROUP BY id    Make it possible to use the new GNU regexp library instead of the current one (the GNU library should be much faster than the old one).    Change so that ALTER TABLE doesn't abort clients that execute INSERT DELAYED.    Fix  so  that  when  columns  are  referenced  in  an  UPDATE  clause,  they  contain  the  old values from before the update started.    Add simulation of pread()/pwrite() on Windows to enable concurrent inserts.    A log le analyser that could parse out information about which tables are hit most often, how often multi-table joins are executed, etc.  It should help users identify areas or table design that could be optimised to execute much more ecient queries.    Add SUM(DISTINCT).    Add  ANY(),  EVERY(), and  SOME()  group functions.  In ANSI SQL these work only on boolean  columns,  but  we  can  extend  these  to  work  on  any  columns/expressions  by applying:  value == 0 -> FALSE and value <> 0 -> TRUE.    Fix that the type for MAX(column) is the same as the column type: mysql> CREATE TABLE t1 (a DATE); mysql> INSERT INTO t1 VALUES (NOW()); mysql> CREATE TABLE t2 SELECT MAX(a) FROM t1; mysql> SHOW COLUMNS FROM t2;    Come up with a nice syntax for a statement that will  UPDATE  the row if it exists and INSERT  a new row if the row didn't exist (like  REPLACE  works with  INSERT  /  DELETE). 1.8.4  Things That Have to be Done Sometime    Implement function:  get_changed_tables(timeout,table1,table2,...).    Change reading through tables to use memmap when possible.  Now only compressed tables use memmap.    Make the automatic timestamp code nicer.   Add timestamps to the update log with SET TIMESTAMP=#;.    Use read/write mutex in some places to get more speed.    Full  foreign  key  support  in  for  MyISAM  tables,  probably  after  the  implementation  of stored procedures with triggers.    Simple views ( rst on one table, later on any expression).    Automatically  close  some  tables  if  a  table,  temporary  table,  or  temporary   les  gets error 23 (not enough open les).    When one nds a eld=#, change all occurrences of eld to #.  Now this is only done for some simple cases.
     

    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
    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