<< 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
    676 MySQL Technical Reference for Version 4.0.3    Added LOG2() function (useful for nding out how many bits a number would require for storage).    Added  LN()  natural logarithm function for compatibility with other databases.  It is synonymous with LOG(X). D.1.2  Changes in release 4.0.2 (01 July 2002)    Changed  --chroot=path  option  to  execute  chroot()  immediately  after  all  options have been parsed.    Don't allow database names that contain `\'.    lower_case_table_names now also a ects created and dropped databases.    Added XOR operator (logical and bitwise XOR) with ^ as a synonym for bitwise XOR.    Added function IS_FREE_LOCK("lock_name"). Based on code contributed by Hartmut Holzgraefe hartmut@six.de.    Removed mysql_ssl_clear() from C API, as it was not needed.    DECIMAL and NUMERIC types can now read exponential numbers.    Added  SHA1()  function  to  calculate  160  bit  hash  value  as  described  in  RFC  3174 (Secure Hash Algorithm).  This function can be considered a cryptographically more secure equivalent of MD5().  See Section 6.3.6.2 [Miscellaneous functions], page 439.    Added AES_ENCRYPT() and AES_DECRYPT() functions to perform encryption according to AES standard (Rijndael).  See Section 6.3.6.2 [Miscellaneous functions], page 439.    Added  --single-transaction  option  to  mysqldump,  allowing  a  consistent  dump  of InnoDB  tables.  See  Section 4.8.5 [mysqldump], page 299.    Fixed bug in innodb_log_group_home_dir in SHOW VARIABLES.    Fixed a bug in optimiser with merge tables when non-unique values are used in summing up (causing crashes).    Fixed  a  bug  in  optimiser  when  a  range  speci ed  makes  index  grouping  impossible (causing crashes).    Fixed a rare bug when FULLTEXT index is present and no tables are used.    Added  privileges   CREATE TEMPORARY TABLES,   EXECUTE,   LOCK TABLES,   REPLICATION CLIENT,  REPLICATION SLAVE,  SHOW DATABASES  and  SUPER.   To  use  these,  you  must have run the mysql_fix_privilege_tables script after upgrading.    Fixed query cache align data bug.    Fixed mutex bug in replication when reading from master fails.    Added missing mutex in TRUNCATE TABLE; This xes some core dump/hangup problems when using TRUNCATE TABLE.    Fixed bug in multi-table DELETE when optimiser uses only indices.    Fixed  that  ALTER TABLE table_name RENAME new_table_name  is  as  fast  as  RENAME TABLE.    Fixed bug in  GROUP BY  with two or more elds,  where at least one eld can contain NULL  values.
     

    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