reference manuals search engine

MySQL Reference Manual - 4.0.20

C.2 Changes in release 4.1.x (Alpha)

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). See section Subquery Syntax.

• 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.) See section INSERT Syntax.

• A newly designed GROUP_CONCAT() aggregate function. See section Functions and Modifiers for Use with GROUP BY Clauses.

• Extensive Unicode (UTF8) support.

• 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). See section Spatial Extensions in MySQL.

• SHOW WARNINGS shows warnings for the last command. See section SHOW WARNINGS.

• Faster binary protocol with prepared statements and parameter binding. See section C API Prepared Statements.

• You can now issue multiple statements with a single C API call and then read the results in one go. See section C API Handling of Multiple Query Execution.

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

This document was generated on July, 26 2004 using texi2html 1.70.