(mysql.info.gz) News-4

 
 D.2 Changes in release 4.1.x (Production)
 =========================================
 
 Version 4.1 of the MySQL server includes many enhancements and new
 features.  Binaries for this version are available for download at
 `http://dev.mysql.com/downloads/mysql-4.1.html'.
 
    * Subqueries and derived tables (unnamed views).   Subqueries.
 
    * `INSERT ... ON DUPLICATE KEY UPDATE ...' syntax.  This allows you
      to `UPDATE' an existing row if the insert would cause a duplicate
      value in a `PRIMARY' or `UNIQUE' key. (`REPLACE' allows you to
      overwrite an existing row, which is something entirely different.)
       INSERT.
 
    * A newly designed `GROUP_CONCAT()' aggregate function.   Group
      by functions and modifiers.
 
    * Extensive Unicode (UTF8) support.
 
    * Table names and column names now are stored in `UTF8'. This makes
      MySQL more flexible, but might cause some problems upgrading if
      you have table or column names that use characters outside of the
      standard 7-bit US-ASCII range.   Upgrading-from-4.0.
 
    * Character sets can be defined per column, table, and database.
 
    * New key cache for `MyISAM' tables with many tunable parameters.
      You can have multiple key caches, preload index into caches for
      batches...
 
    * `BTREE' index on `HEAP' tables.
 
    * Support for OpenGIS spatial types (geographical data).  
      Spatial extensions in MySQL.
 
    * `SHOW WARNINGS' shows warnings for the last command.   `SHOW
      WARNINGS' SHOW WARNINGS.
 
    * Faster binary protocol with prepared statements and parameter
      binding.   C API Prepared statements.
 
    * You can now issue multiple statements with a single C API call and
      then read the results in one go.   C API multiple queries.
 
    * Create Table: `CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table2 LIKE
      table1'.
 
    * Server based `HELP' command that can be used in the `mysql'
      command-line client (and other clients) to get help for SQL
      statements.
 
 For a full list of changes, please refer to the changelog sections for
 each individual 4.1.x release.

 
* News-4.1.10                 Changes in release 4.1.10 (not released yet)
* News-4.1.9                  Changes in release 4.1.9 (11 Jan 2005)
* News-4.1.8                  Changes in release 4.1.8 (14 Dec 2004)
* News-4.1.7                  Changes in release 4.1.7 (23 Oct 2004: Production)
* News-4.1.6                  Changes in release 4.1.6 (10 Oct 2004)
* News-4.1.5                  Changes in release 4.1.5 (16 Sep 2004)
* News-4.1.4                  Changes in release 4.1.4 (26 Aug 2004: Gamma)
* News-4.1.3                  Changes in release 4.1.3 (28 Jun 2004: Beta)
* News-4.1.2                  Changes in release 4.1.2 (28 May 2004)
* News-4.1.1                  Changes in release 4.1.1 (01 Dec 2003)
* News-4.1.0                  Changes in release 4.1.0 (03 Apr 2003: Alpha)

Info Catalog

(mysql.info.gz) News-5

(mysql.info.gz) News

(mysql.info.gz) News-4

automatically generated byinfo2html

(mysql.info.gz) News-4

Menu