D.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://www.mysql.com/downloads/mysql-4.1.html.

• Subqueries:

  SELECT * FROM t1 WHERE t1.a=(SELECT t2.b FROM t2);
  
  SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM t2);
  

• Derived tables:

  SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;
  

• 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 6.4.3 INSERT Syntax.
• A newly designed GROUP_CONCAT() aggregate function. See section 6.3.7 Functions and Modifiers for Use with GROUP BY Clauses.
• Extensive Unicode (UTF8) support.
• Character sets can be defined per column, table and database.
• BTREE index on HEAP tables.
• Support for OpenGIS (Geographical data). See section 11 Spatial Extensions in MySQL.
• SHOW WARNINGS shows warnings for the last command. See section 4.5.7.9 SHOW WARNINGS | ERRORS.
• Faster binary protocol with prepared statements and parameter binding. See section 9.1.4 C API Prepared Statements.
• Multi-line queries: You can now issue several queries at once and then read the results in one go. See section 9.1.8 C API Handling of Multiple Query Execution.
• Create Table: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table LIKE table.
• Server based HELP command that can be used in the mysql command line client (and other clients) to get help for SQL commands.

For a full list of changes, please refer to the changelog sections for each individual 4.1.x release.

Subsections

• D.2.1 Changes in release 4.1.1 (not released yet)
• D.2.2 Changes in release 4.1.0 (03 Apr 2003: Alpha)

User Comments

Hello

do you intend also to add UPDATE ... ON DUPLICATE KEY UPDATE ... ?

Thanks

Add your own comment.