|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
[+/-]
- B.1.1. Changes in MySQL 4.1.25 (Not yet released)
- 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.1.2. Changes in MySQL 4.1.24 (01 March 2008)
End of Product Lifecycle. Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended. However, for MySQL 4.0 and 4.1, there is still extended support available. For details, see http://www.mysql.com/company/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see http://www.mysql.com/company/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 4.0 and 4.1. Please consider upgrading to a recent version (MySQL 5.0 or 5.1).
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
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, “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.5.4.21, “SHOW WARNINGSSyntaxâ€.Faster binary protocol with prepared statements and parameter binding. See Section 17.2.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.2.9, “C API Handling of 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.
For a full list of changes, please refer to the changelog sections for each individual 4.1.x release.
|
Contact Us Legal Notices Order Services Online Pantek Home Privacy Policy IT news Site Map Pantek Library |
User Comments
Add your own comment.