version 5.5 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 5.0 YET
Discuss version 5.5 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 5.0 YET in the MySQL Help forum on Dev Shed. version 5.5 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 5.0 YET MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Receive the tools necessary to be the rock star of your field. Our 12-month program teaches you the evolving world of multi-channel marketing as well as the complex issues and opportunities found in the industry.
ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month! Download and Activate to enter!
Web development can be a daunting task, even for specialists. There is a lot of information to absorb and a lot of technologies to learn in order to manage a superior website. When trying to learn the ropes, developers need a reliable source to introduce new ideas that can be easily implemented. When working on large projects, even web veterans may run into a technology or an aspect of a technology that they are unfamiliar with.
Posts: 25,046
Time spent in forums: 3 Months 2 Days 22 h 44 sec
Reputation Power: 3829
version 5.5 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 5.0 YET
mysql version 4.1 has been in production status since october, 2004
if you're not on 4.1 yet, and you post a problem and wish to receive a solution involving sql, it is your responsibility to mention which version you're on
otherwise, you might get a solution using sql that works only in 4.1
deal?
EDIT: we've updated the thread to reflect that 5.5 is current, and you shouldn't post a question without mentioning your version if your version is below 5.0
Posts: 704
Time spent in forums: 3 Days 8 h 36 m 26 sec
Reputation Power: 59
My favorite is the unicode support and how it was implemented. I just can't understand why data types like NCHAR, NVARCHAR, etc. exist after I see how MySQL did it. I'm sure there are reasons, I just can't conceive them right now. Oh well.
Oh, and the subqueries are especially nice when you're migrating from one DBMS to MySQL.
__________________
blockcipher
---------------
Gratuitously stolen...
mysql> SELECT * FROM user WHERE clue > 0;
0 Results Returned.
Posts: 14,557
Time spent in forums: 3 Months 5 Days 6 h 4 m 31 sec
Reputation Power: 4042
I like how easy it is to set character sets when creating tables. Made it very easy to add support for UTF-8, Shift_JS, Big5, etc to my program, so long as you also use the same character set for htmlentitites() (when using PHP, obviously).
Posts: 154
Time spent in forums: 1 Day 18 h 32 m 24 sec
Reputation Power: 8
Quote:
Originally Posted by Sepodati
I like how easy it is to set character sets when creating tables. Made it very easy to add support for UTF-8, Shift_JS, Big5, etc to my program, so long as you also use the same character set for htmlentitites() (when using PHP, obviously).
Posts: 276
Time spent in forums: 1 Day 21 h 35 m 58 sec
Reputation Power: 7
My main interest in version 5.0 is speed the improvements made to SELECT queries using OR.
Quote:
No matter which index MySQL selects, it has to perform a full table scan to satisfy the other condition. Queries using OR conditions prevent MySQL from easily eliminating candidate rows. So rather than use one index to find some of the rows and then perform the table scan, MySQL decides that it's faster to simply use a table scan. This is slated to be fixed in MySQL 5.0.
- O'Reilly High Performance MySQL
Posts: 3
Time spent in forums: 2 h 25 sec
Reputation Power: 0
Ive recently upgraded from Mysql 4.1 to 5, and found very little problems with the change. The only real problem i found was that i had the odd field that was named on a reserve word in 5 but not in 4.1, so some queries broke.
Other than that, make sure you back your data up and do a table check after the upgrade.
Posts: 332
Time spent in forums: 3 Days 16 h 12 m 50 sec
Reputation Power: 39
Note that the above (5.2.x) and 5.1.x, are still Beta and are not recommended for Production use. For production, you should use the latest stable release of 5.0, which for the community is 5.0.41:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Now MySQL 5.0 production release available !!!
Linear Mode
