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
* 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.)
* 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
* `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
* Server based `HELP' command that can be used in the `mysql'
command-line client (and other clients) to get help for SQL
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)
automatically generated byinfo2html