- D MySQL Change History
- D.1 Changes in Release 5.0.x (Production)
- D.1.1 Changes in MySQL 5.0.94 (05 July 2011)
- D.1.2 Changes in MySQL 5.0.93 (05 May 2011)
- D.1.3 Changes in MySQL 5.0.92 (07 February 2011)
- D.1.4 Changes in MySQL 5.0.91 (05 May 2010)
- D.1.5 Changes in MySQL 5.0.90 (15 January 2010)
- D.1.6 Changes in MySQL 5.0.89 (02 December 2009)
- D.1.7 Changes in MySQL 5.0.88 (04 November 2009)
- D.1.8 Changes in MySQL Enterprise 5.0.87sp1 [QSP] (03 February 2010)
- D.1.9 Changes in MySQL 5.0.87 (15 October 2009)
- D.1.10 Changes in MySQL 5.0.86 (09 September 2009)
- D.1.11 Changes in MySQL 5.0.85 (11 August 2009)
- D.1.12 Changes in MySQL Enterprise 5.0.84sp1 [QSP] (30 September 2009)
- D.1.13 Changes in MySQL 5.0.84 (07 July 2009)
- D.1.14 Changes in MySQL 5.0.83 (29 May 2009)
- D.1.15 Changes in MySQL Enterprise 5.0.82sp1 [QSP] (21 July 2009)
- D.1.16 Changes in MySQL 5.0.82 (20 May 2009)
- D.1.17 Changes in MySQL Community Server 5.0.81 (01 May 2009)
- D.1.18 Changes in MySQL Enterprise 5.0.80 [MRU] (01 May 2009)
- D.1.19 Changes in MySQL Enterprise 5.0.79 [MRU] (09 March 2009)
- D.1.20 Changes in MySQL Enterprise 5.0.78 [MRU] (06 February 2009)
- D.1.21 Changes in MySQL Community Server 5.0.77 (28 January 2009)
- D.1.22 Changes in MySQL Enterprise 5.0.76 [MRU] (05 January 2009)
- D.1.23 Changes in MySQL Community Server 5.0.75 (17 December 2008)
- D.1.24 Changes in MySQL Enterprise 5.0.74sp1 [QSP] (30 April 2009)
- D.1.25 Changes in MySQL Enterprise 5.0.74 [MRU] (03 December 2008)
- D.1.26 Changes in MySQL Enterprise 5.0.72sp1 [QSP] (13 January 2009)
- D.1.27 Changes in MySQL Enterprise 5.0.72 [MRU] (24 October 2008)
- D.1.28 Changes in MySQL Enterprise 5.0.70 [MRU] (27 September 2008)
- D.1.29 Changes in MySQL Enterprise 5.0.68 [MRU] (13 August 2008)
- D.1.30 Changes in MySQL Community Server 5.0.67 (04 August 2008)
- D.1.31 Changes in MySQL Enterprise 5.0.66sp1 [QSP] (23 October 2008)
- D.1.32 Changes in MySQL Enterprise 5.0.66a [MRU] (16 July 2008)
- D.1.33 Changes in MySQL Enterprise 5.0.66 [MRU] (09 July 2008)
- D.1.34 Changes in MySQL Enterprise 5.0.64 [MRU] (10 June 2008)
- D.1.35 Changes in MySQL Enterprise 5.0.62 [MRU] (12 May 2008)
- D.1.36 Changes in MySQL Enterprise 5.0.60sp1 [QSP] (27 June 2008)
- D.1.37 Changes in MySQL Enterprise 5.0.60 [MRU] (28 April 2008)
- D.1.38 Changes in MySQL Enterprise 5.0.58 [MRU] (05 March 2008)
- D.1.39 Changes in MySQL Enterprise 5.0.56sp1 [QSP] (30 March 2008)
- D.1.40 Changes in MySQL Enterprise 5.0.56 [MRU] (06 February 2008)
- D.1.41 Changes in MySQL Enterprise 5.0.54a [MRU] (11 January 2008)
- D.1.42 Changes in MySQL Enterprise 5.0.54 [MRU] (14 December 2007)
- D.1.43 Changes in MySQL Enterprise 5.0.52 [MRU] (30 November 2007)
- D.1.44 Changes in MySQL Community Server 5.0.51b (24 April 2008)
- D.1.45 Changes in MySQL Community Server 5.0.51a (11 January 2008)
- D.1.46 Changes in MySQL Community Server 5.0.51 (15 November 2007)
- D.1.47 Changes in MySQL Enterprise 5.0.50sp1a [QSP] (11 January 2008)
- D.1.48 Changes in MySQL Enterprise 5.0.50sp1 [QSP] (12 December 2007)
- D.1.49 Changes in MySQL Enterprise 5.0.50 [MRU] (19 October 2007)
- D.1.50 Changes in MySQL Enterprise 5.0.48 [MRU] (27 August 2007)
- D.1.51 Changes in MySQL Enterprise 5.0.46 [MRU] (13 July 2007)
- D.1.52 Changes in MySQL Community Server 5.0.45 (04 July 2007)
- D.1.53 Changes in MySQL Enterprise 5.0.44sp1 [QSP] (01 August 2007)
- D.1.54 Changes in MySQL Enterprise 5.0.44 [MRU] (21 June 2007)
- D.1.55 Changes in MySQL Enterprise 5.0.42 [MRU] (23 May 2007)
- D.1.56 Changes in MySQL Community Server 5.0.41 (01 May 2007)
- D.1.57 Changes in MySQL Enterprise 5.0.40 [MRU] (17 April 2007)
- D.1.58 Changes in MySQL Enterprise 5.0.38 [MRU] (20 March 2007)
- D.1.59 Changes in MySQL Community Server 5.0.37 (27 February 2007)
- D.1.60 Changes in MySQL Enterprise 5.0.36sp1 [QSP] (12 April 2007)
- D.1.61 Changes in MySQL Enterprise 5.0.36 [MRU] (20 February 2007)
- D.1.62 Changes in MySQL Enterprise 5.0.34 [MRU] (17 January 2007)
- D.1.63 Changes in MySQL Community Server 5.0.33 (09 January 2007)
- D.1.64 Changes in MySQL Enterprise 5.0.32 [MRU] (20 December 2006)
- D.1.65 Changes in MySQL Enterprise 5.0.30sp1 [QSP] (19 January 2007)
- D.1.66 Changes in MySQL Enterprise 5.0.30 [MRU] (14 November 2006)
- D.1.67 Changes in MySQL Enterprise 5.0.28 (24 October 2006)
- D.1.68 Changes in MySQL Community Server 5.0.27 (21 October 2006)
- D.1.69 Changes in MySQL 5.0.26 (03 October 2006)
- D.1.70 Changes in MySQL 5.0.25 (15 September 2006)
- D.1.71 Changes in MySQL 5.0.24a (25 August 2006)
- D.1.72 Changes in MySQL 5.0.24 (27 July 2006)
- D.1.73 Changes in MySQL 5.0.23 (Not released)
- D.1.74 Changes in MySQL 5.0.22 (24 May 2006)
- D.1.75 Changes in MySQL 5.0.21 (02 May 2006)
- D.1.76 Changes in MySQL 5.0.20a (18 April 2006)
- D.1.77 Changes in MySQL 5.0.20 (31 March 2006)
- D.1.78 Changes in MySQL 5.0.19 (04 March 2006)
- D.1.79 Changes in MySQL 5.0.18 (21 December 2005)
- D.1.80 Changes in MySQL 5.0.17 (14 December 2005)
- D.1.81 Changes in MySQL 5.0.16 (10 November 2005)
- D.1.82 Changes in MySQL 5.0.15 (19 October 2005, Production)
- D.1.83 Changes in MySQL 5.0.14 (Not released)
- D.1.84 Changes in MySQL 5.0.13 (22 September 2005, Release Candidate)
- D.1.85 Changes in MySQL 5.0.12 (02 September 2005)
- D.1.86 Changes in MySQL 5.0.11 (06 August 2005)
- D.1.87 Changes in MySQL 5.0.10 (27 July 2005)
- D.1.88 Changes in MySQL 5.0.9 (15 July 2005)
- D.1.89 Changes in MySQL 5.0.8 (Not released)
- D.1.90 Changes in MySQL 5.0.7 (10 June 2005)
- D.1.91 Changes in MySQL 5.0.6 (26 May 2005)
- D.1.92 Changes in MySQL 5.0.5 (Not released)
- D.1.93 Changes in MySQL 5.0.4 (16 April 2005)
- D.1.94 Changes in MySQL 5.0.3 (23 March 2005, Beta)
- D.1.95 Changes in MySQL 5.0.2 (01 December 2004)
- D.1.96 Changes in MySQL 5.0.1 (27 July 2004)
- D.1.97 Changes in MySQL 5.0.0 (22 December 2003, Alpha)
- D.2 Changes in MySQL Cluster
- D.3 MySQL Connector/ODBC (MyODBC) Change History
- D.4 MySQL Connector/Net Change History
- D.5 MySQL Visual Studio Plugin Change History
- D.6 MySQL Connector/J Change History
- D.7 MySQL Connector/MXJ Change History
- D.8 MySQL Proxy Change History
[+/-]
- D.1.1. Changes in MySQL 5.0.94 (05 July 2011)
- D.1.2. Changes in MySQL 5.0.93 (05 May 2011)
- D.1.3. Changes in MySQL 5.0.92 (07 February 2011)
- D.1.4. Changes in MySQL 5.0.91 (05 May 2010)
- D.1.5. Changes in MySQL 5.0.90 (15 January 2010)
- D.1.6. Changes in MySQL 5.0.89 (02 December 2009)
- D.1.7. Changes in MySQL 5.0.88 (04 November 2009)
- D.1.8. Changes in MySQL Enterprise 5.0.87sp1 [QSP] (03 February 2010)
- D.1.9. Changes in MySQL 5.0.87 (15 October 2009)
- D.1.10. Changes in MySQL 5.0.86 (09 September 2009)
- D.1.11. Changes in MySQL 5.0.85 (11 August 2009)
- D.1.12. Changes in MySQL Enterprise 5.0.84sp1 [QSP] (30 September 2009)
- D.1.13. Changes in MySQL 5.0.84 (07 July 2009)
- D.1.14. Changes in MySQL 5.0.83 (29 May 2009)
- D.1.15. Changes in MySQL Enterprise 5.0.82sp1 [QSP] (21 July 2009)
- D.1.16. Changes in MySQL 5.0.82 (20 May 2009)
- D.1.17. Changes in MySQL Community Server 5.0.81 (01 May 2009)
- D.1.18. Changes in MySQL Enterprise 5.0.80 [MRU] (01 May 2009)
- D.1.19. Changes in MySQL Enterprise 5.0.79 [MRU] (09 March 2009)
- D.1.20. Changes in MySQL Enterprise 5.0.78 [MRU] (06 February 2009)
- D.1.21. Changes in MySQL Community Server 5.0.77 (28 January 2009)
- D.1.22. Changes in MySQL Enterprise 5.0.76 [MRU] (05 January 2009)
- D.1.23. Changes in MySQL Community Server 5.0.75 (17 December 2008)
- D.1.24. Changes in MySQL Enterprise 5.0.74sp1 [QSP] (30 April 2009)
- D.1.25. Changes in MySQL Enterprise 5.0.74 [MRU] (03 December 2008)
- D.1.26. Changes in MySQL Enterprise 5.0.72sp1 [QSP] (13 January 2009)
- D.1.27. Changes in MySQL Enterprise 5.0.72 [MRU] (24 October 2008)
- D.1.28. Changes in MySQL Enterprise 5.0.70 [MRU] (27 September 2008)
- D.1.29. Changes in MySQL Enterprise 5.0.68 [MRU] (13 August 2008)
- D.1.30. Changes in MySQL Community Server 5.0.67 (04 August 2008)
- D.1.31. Changes in MySQL Enterprise 5.0.66sp1 [QSP] (23 October 2008)
- D.1.32. Changes in MySQL Enterprise 5.0.66a [MRU] (16 July 2008)
- D.1.33. Changes in MySQL Enterprise 5.0.66 [MRU] (09 July 2008)
- D.1.34. Changes in MySQL Enterprise 5.0.64 [MRU] (10 June 2008)
- D.1.35. Changes in MySQL Enterprise 5.0.62 [MRU] (12 May 2008)
- D.1.36. Changes in MySQL Enterprise 5.0.60sp1 [QSP] (27 June 2008)
- D.1.37. Changes in MySQL Enterprise 5.0.60 [MRU] (28 April 2008)
- D.1.38. Changes in MySQL Enterprise 5.0.58 [MRU] (05 March 2008)
- D.1.39. Changes in MySQL Enterprise 5.0.56sp1 [QSP] (30 March 2008)
- D.1.40. Changes in MySQL Enterprise 5.0.56 [MRU] (06 February 2008)
- D.1.41. Changes in MySQL Enterprise 5.0.54a [MRU] (11 January 2008)
- D.1.42. Changes in MySQL Enterprise 5.0.54 [MRU] (14 December 2007)
- D.1.43. Changes in MySQL Enterprise 5.0.52 [MRU] (30 November 2007)
- D.1.44. Changes in MySQL Community Server 5.0.51b (24 April 2008)
- D.1.45. Changes in MySQL Community Server 5.0.51a (11 January 2008)
- D.1.46. Changes in MySQL Community Server 5.0.51 (15 November 2007)
- D.1.47. Changes in MySQL Enterprise 5.0.50sp1a [QSP] (11 January 2008)
- D.1.48. Changes in MySQL Enterprise 5.0.50sp1 [QSP] (12 December 2007)
- D.1.49. Changes in MySQL Enterprise 5.0.50 [MRU] (19 October 2007)
- D.1.50. Changes in MySQL Enterprise 5.0.48 [MRU] (27 August 2007)
- D.1.51. Changes in MySQL Enterprise 5.0.46 [MRU] (13 July 2007)
- D.1.52. Changes in MySQL Community Server 5.0.45 (04 July 2007)
- D.1.53. Changes in MySQL Enterprise 5.0.44sp1 [QSP] (01 August 2007)
- D.1.54. Changes in MySQL Enterprise 5.0.44 [MRU] (21 June 2007)
- D.1.55. Changes in MySQL Enterprise 5.0.42 [MRU] (23 May 2007)
- D.1.56. Changes in MySQL Community Server 5.0.41 (01 May 2007)
- D.1.57. Changes in MySQL Enterprise 5.0.40 [MRU] (17 April 2007)
- D.1.58. Changes in MySQL Enterprise 5.0.38 [MRU] (20 March 2007)
- D.1.59. Changes in MySQL Community Server 5.0.37 (27 February 2007)
- D.1.60. Changes in MySQL Enterprise 5.0.36sp1 [QSP] (12 April 2007)
- D.1.61. Changes in MySQL Enterprise 5.0.36 [MRU] (20 February 2007)
- D.1.62. Changes in MySQL Enterprise 5.0.34 [MRU] (17 January 2007)
- D.1.63. Changes in MySQL Community Server 5.0.33 (09 January 2007)
- D.1.64. Changes in MySQL Enterprise 5.0.32 [MRU] (20 December 2006)
- D.1.65. Changes in MySQL Enterprise 5.0.30sp1 [QSP] (19 January 2007)
- D.1.66. Changes in MySQL Enterprise 5.0.30 [MRU] (14 November 2006)
- D.1.67. Changes in MySQL Enterprise 5.0.28 (24 October 2006)
- D.1.68. Changes in MySQL Community Server 5.0.27 (21 October 2006)
- D.1.69. Changes in MySQL 5.0.26 (03 October 2006)
- D.1.70. Changes in MySQL 5.0.25 (15 September 2006)
- D.1.71. Changes in MySQL 5.0.24a (25 August 2006)
- D.1.72. Changes in MySQL 5.0.24 (27 July 2006)
- D.1.73. Changes in MySQL 5.0.23 (Not released)
- D.1.74. Changes in MySQL 5.0.22 (24 May 2006)
- D.1.75. Changes in MySQL 5.0.21 (02 May 2006)
- D.1.76. Changes in MySQL 5.0.20a (18 April 2006)
- D.1.77. Changes in MySQL 5.0.20 (31 March 2006)
- D.1.78. Changes in MySQL 5.0.19 (04 March 2006)
- D.1.79. Changes in MySQL 5.0.18 (21 December 2005)
- D.1.80. Changes in MySQL 5.0.17 (14 December 2005)
- D.1.81. Changes in MySQL 5.0.16 (10 November 2005)
- D.1.82. Changes in MySQL 5.0.15 (19 October 2005, Production)
- D.1.83. Changes in MySQL 5.0.14 (Not released)
- D.1.84. Changes in MySQL 5.0.13 (22 September 2005, Release Candidate)
- D.1.85. Changes in MySQL 5.0.12 (02 September 2005)
- D.1.86. Changes in MySQL 5.0.11 (06 August 2005)
- D.1.87. Changes in MySQL 5.0.10 (27 July 2005)
- D.1.88. Changes in MySQL 5.0.9 (15 July 2005)
- D.1.89. Changes in MySQL 5.0.8 (Not released)
- D.1.90. Changes in MySQL 5.0.7 (10 June 2005)
- D.1.91. Changes in MySQL 5.0.6 (26 May 2005)
- D.1.92. Changes in MySQL 5.0.5 (Not released)
- D.1.93. Changes in MySQL 5.0.4 (16 April 2005)
- D.1.94. Changes in MySQL 5.0.3 (23 March 2005, Beta)
- D.1.95. Changes in MySQL 5.0.2 (01 December 2004)
- D.1.96. Changes in MySQL 5.0.1 (27 July 2004)
- D.1.97. Changes in MySQL 5.0.0 (22 December 2003, Alpha)
End of Product Lifecycle. Active development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products (http://www.oracle.com/us/support/lifetime-support/index.html). Please consider upgrading to a recent version.
An overview of features added in MySQL 5.0 can be found here: Section 1.4, “What Is New in MySQL 5.0”.
The following list summarizes what has been done in MySQL 5.0. For a full list of changes, please refer to the changelog sections for individual 5.0 releases.
For discussion of upgrade issues that you may encounter for upgrades from MySQL 4.1 to MySQL 5.0, see Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”.
VARCHARandVARBINARYcolumns retain trailing spaces. AVARCHAR()orVARBINARYcolumn can contain up to 65,535 characters or bytes, respectively.Strict SQL mode, which causes an error instead of a warning when inserting an incorrect value into a column. See Section 5.1.6, “Server SQL Modes”.
A new fixed-point math library supports precision math, resulting in more accurate results when working with the
DECIMALandNUMERICdata types. For details, see Section 11.17, “Precision Math”.Basic support for views. See Section 17.4, “Using Views”.
Basic support for stored procedures and functions (SQL:2003 style). See Section 17.2, “Using Stored Routines (Procedures and Functions)”.
Basic support for triggers. See Section 17.3, “Using Triggers”.
Basic support for read-only server side cursors. For information about using cursors within stored routines, see Section 12.6.6, “Cursors”. For information about using cursors from within the C API, see Section 19.8.7.3, “
mysql_stmt_attr_set()”.Support for
SELECT INTO, where the variables can be a mix of global and local types. See Section 12.2.8.1, “list_of_varsSELECT ... INTOSyntax”.MEMORY(HEAP) tables can haveVARCHARcolumns.-
When using a constant string or a function that generates a string result in
CREATE ... SELECT, MySQL creates the result column based on the maximum length of the string or expression:Maximum Length Data type = 0 CHAR(0)< 512 VARCHAR(max_length)>= 512 TEXT Removed the update log. It is fully replaced by the binary log. If the MySQL server is started with
--log-update, it is translated to--log-bin(or ignored if the server is explicitly started with--log-bin), and a warning message is written to the error log. Settingsql_log_updatesilently setssql_log_bininstead (or do nothing if the server is explicitly started with--log-bin).Removed support for the
ISAMstorage engine. If you haveISAMtables, you should convert them before upgrading. See Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”.Removed support for
RAIDoptions inMyISAMtables. If you have tables that use these options, you should convert them before upgrading. See Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”.
User Comments
Add your own comment.