- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- B MySQL Change History
- B.1 Changes in Release 4.1.x (Production)
- B.1.1 Changes in MySQL 4.1.25 (01 December 2008)
- B.1.2 Changes in MySQL 4.1.24 (01 March 2008)
- B.1.3 Changes in MySQL 4.1.23 (12 June 2007)
- B.1.4 Changes in MySQL 4.1.22 (02 November 2006)
- B.1.5 Changes in MySQL 4.1.21 (19 July 2006)
- B.1.6 Changes in MySQL 4.1.20 (24 May 2006)
- B.1.7 Changes in MySQL 4.1.19 (29 April 2006)
- B.1.8 Changes in MySQL 4.1.18 (27 January 2006)
- B.1.9 Changes in MySQL 4.1.17 (Not released)
- B.1.10 Changes in MySQL 4.1.16 (29 November 2005)
- B.1.11 Changes in MySQL 4.1.15 (13 October 2005)
- B.1.12 Changes in MySQL 4.1.14 (17 August 2005)
- B.1.13 Changes in MySQL 4.1.13 (15 July 2005)
- B.1.14 Changes in MySQL 4.1.12 (13 May 2005)
- B.1.15 Changes in MySQL 4.1.11 (01 April 2005)
- B.1.16 Changes in MySQL 4.1.10 (12 February 2005)
- B.1.17 Changes in MySQL 4.1.9 (11 January 2005)
- B.1.18 Changes in MySQL 4.1.8 (14 December 2004)
- B.1.19 Changes in MySQL 4.1.7 (23 October 2004 Production)
- B.1.20 Changes in MySQL 4.1.6 (10 October 2004)
- B.1.21 Changes in MySQL 4.1.5 (16 September 2004)
- B.1.22 Changes in MySQL 4.1.4 (26 August 2004 Gamma)
- B.1.23 Changes in MySQL 4.1.3 (28 June 2004 Beta)
- B.1.24 Changes in MySQL 4.1.2 (28 May 2004)
- B.1.25 Changes in MySQL 4.1.1 (01 December 2003)
- B.1.26 Changes in MySQL 4.1.0 (03 April 2003 Alpha)
- B.2 Changes in Release 4.0.x
- B.3 Changes in Release 3.23.x
- B.4 Changes in InnoDB
- B.5 Changes in MySQL Cluster
- B.6 MySQL Connector/ODBC (MyODBC) Change History
- B.7 MySQL Connector/NET Change History
- B.8 MySQL Connector/J Change History
- B.9 MySQL Connector/MXJ Change History
[+/-]
- B.1.1. Changes in MySQL 4.1.25 (01 December 2008)
- B.1.2. Changes in MySQL 4.1.24 (01 March 2008)
- B.1.3. Changes in MySQL 4.1.23 (12 June 2007)
- B.1.4. Changes in MySQL 4.1.22 (02 November 2006)
- B.1.5. Changes in MySQL 4.1.21 (19 July 2006)
- B.1.6. Changes in MySQL 4.1.20 (24 May 2006)
- B.1.7. Changes in MySQL 4.1.19 (29 April 2006)
- B.1.8. Changes in MySQL 4.1.18 (27 January 2006)
- B.1.9. Changes in MySQL 4.1.17 (Not released)
- B.1.10. Changes in MySQL 4.1.16 (29 November 2005)
- B.1.11. Changes in MySQL 4.1.15 (13 October 2005)
- B.1.12. Changes in MySQL 4.1.14 (17 August 2005)
- B.1.13. Changes in MySQL 4.1.13 (15 July 2005)
- B.1.14. Changes in MySQL 4.1.12 (13 May 2005)
- B.1.15. Changes in MySQL 4.1.11 (01 April 2005)
- B.1.16. Changes in MySQL 4.1.10 (12 February 2005)
- B.1.17. Changes in MySQL 4.1.9 (11 January 2005)
- B.1.18. Changes in MySQL 4.1.8 (14 December 2004)
- B.1.19. Changes in MySQL 4.1.7 (23 October 2004 Production)
- B.1.20. Changes in MySQL 4.1.6 (10 October 2004)
- B.1.21. Changes in MySQL 4.1.5 (16 September 2004)
- B.1.22. Changes in MySQL 4.1.4 (26 August 2004 Gamma)
- B.1.23. Changes in MySQL 4.1.3 (28 June 2004 Beta)
- B.1.24. Changes in MySQL 4.1.2 (28 May 2004)
- B.1.25. Changes in MySQL 4.1.1 (01 December 2003)
- B.1.26. Changes in MySQL 4.1.0 (03 April 2003 Alpha)
End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
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.
The following list summarizes what has been done in the 4.1 tree. For a full list of changes, please refer to the changelog sections for each individual 4.1 release.
The
SUBSTRING()function can now take a negative value for thepos(position) argument. See Section 11.4, “String Functions”.Subqueries and derived tables (unnamed views). See Section 12.2.8, “Subquery Syntax”.
INSERT ... ON DUPLICATE KEY UPDATE ...syntax. This allows you toUPDATEan existing row if the insert would cause a duplicate value in aPRIMARYorUNIQUEkey. (REPLACEallows you to overwrite an existing row, which is something entirely different.) See Section 12.2.4, “INSERTSyntax”.A newly designed
GROUP_CONCAT()aggregate function. See Section 11.11, “Functions and Modifiers for Use withGROUP BYClauses”.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. See Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”.Character sets can be defined per column, table, and database.
New key cache for
MyISAMtables with many tunable parameters. You can have multiple key caches, preload index into caches for batches...BTREEindex onHEAPtables.Support for OpenGIS spatial types (geographical data). See Chapter 16, Spatial Extensions.
SHOW WARNINGSshows warnings for the last command. See Section 12.4.5.26, “SHOW WARNINGSSyntax”.Faster binary protocol with prepared statements and parameter binding. See Section 17.6.4, “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 17.6.12, “C API Support for Multiple Statement Execution”.
Create Table:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table2 LIKE table1.Server based
HELPcommand that can be used in the mysql command-line client (and other clients) to get help for SQL statements.
User Comments
Add your own comment.