Download MySQL 4.1.0 alpha

Our junk submitter informed us about the new development release of MySQL 4.1.0 alpha. Many new features have been built in, such as the use of nested select statements that allow you to execute more powerful queries. Please note that this release is not intended for production environments. Look at this one internet page for an overview of all features in version 1.4.0. The release notes look like this:

Hi,

MySQL 4.1.0, a new version of the popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at and mirror sites.

Note that not all mirror sites may be up to date at this point in time – if you can’t find this version on some mirror, please try again later or choose another download site.

This is the first Alpha development release of the 4.1 tree, adding many new features (see below). As this code is currently labeled “Alpha”, we do not recommend that this version be used in production environments yet!

However, we encourage you to test and evaluate it and, more importantly, report any bugs or observations to our bug tracking database at Please note, that for us to resolve a bug report, a reproducible test is required. See “How to report a bug” at for more details before filing a bug report. We appreciate your support!

Some new features include:

• Sub queries:
  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 for more info)
• A newly designed `GROUP_CONCAT()’ aggregate function.
  (See for more info)
• 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 for more info)
• `SHOW WARNINGS’ shows warnings for the last command.
  (See for more info)
• Faster binary protocol with prepared statements and parameter binding.
  (See for more info)
• Multi-line queries: You can now issue several queries at once and then read the results in one go.
• Note C API multiple queries.
  (See for more info)
• 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 more detailed list of changes in MySQL 4.1.0, please also see and

bye,
LenZ