MySQL is like most other software; the higher version numbers indicate later releases of the code and later releases have more features than earlier releases. Therefore, 5.1 has more features than 5.0 and 5.0 has more features than 4.1. To see the new features added in each of these versions, see the appropriate manuals: - New features in 4.1: http://dev.mysql.com/doc/refman/4.1/en/nutshell-4-1-features.html - New features in 5.0: http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html
The developers at MySQL are currently working on 5.1; they know what features they plan to put in it but some of them are probably not there at all while others are still fairly buggy. You can download 5.1 and run it but you shouldn't be surprised if some things don't work or don't work correctly. This might be the thing to do if you want to "play" with the new features that are being added in 5.1 but you probably don't want to use 5.1 for a production system yet. 5.0 (5.0.15 to be exact) stable for production use. 4.1 is also suitable for production use but has fewer features than 5.0. For example, if you need Views, you won't find 4.1 acceptable because it doesn't support Views while 5.0 does. So, look at the features lists and figure out what you need. Then, decide if you want a version of MySQL that you can use in production or just one that will let you play with new features for now and choose the appropriate bundle to download. Rhino ----- Original Message ----- From: "Bing Du" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Monday, November 07, 2005 11:27 AM Subject: what's the relationship among 4.1, 5.0 and 5.1? Hello, Anybody have a good pointer that could help explain why is 4.1, 5.0 and 5.1 respectively? 5.0 had been in development state for a while, now it's finally released. I know 5.0 has added more features. Would 4.x eventually be obsolete and replaced by 5.x? I guess I need some help to understand how there are several versions for the same software and suggestion on which one should be used? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 05/11/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 05/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]