MySQL 4.1.7

MySQL 4.1.7 Publisher's Description:

About MySQL
The world s most popular Open Source Database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation.

Whats New in this Version
- Subqueries and derived tables (unnamed views). See section 14.1.8 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 14.1.4 INSERT Syntax.
- A newly designed GROUP_CONCAT() aggregate function. See section 13.9 Functions and Modifiers for Use with GROUP BY Clauses.
- Many more enhancements.