MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > MySQL Help
Reload this Page

version 5.0 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 4.1 YET

Discuss version 5.0 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 4.1 YET in the MySQL Help forum on Dev Shed.
version 5.0 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 4.1 YET MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old February 19th, 2005, 01:10 PM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 24th Plane (16500 - 16999 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 16,727 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 2 Days 19 h 22 m 42 sec
Reputation Power: 848
version 5.0 is the current version -- PLEASE READ THIS IF YOU'RE NOT ON 4.1 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?
__________________
r937.com | rudy.ca
Reply With Quote
  #2  
Old February 21st, 2005, 04:25 AM
SimonGreenhill's Avatar
SimonGreenhill SimonGreenhill is offline
(retired)
Dev Shed God 11th Plane (10000 - 10499 posts)
  
Join Date: Dec 2003
Location: The Laboratory
Posts: 10,101 SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)  Folding Points: 4925 Folding Title: Novice Folder
Time spent in forums: 3 Months 3 Weeks 5 h 41 m 45 sec
Reputation Power: 1331
Facebook
If you haven't upgraded, what are you waiting for?

Some benefits of 4.1 which may help you decide:

Sub-Queries:
SELECT * FROM table1 WHERE id1 IN
(SELECT id2 FROM table2 WHERE name = 'simon');

More info

Unicode Support:
Fantastic!
More info

Prepared Statements:
More info

Show Warnings & Show Errors:
now you can actually work out what those errors are!

Better Security:
Now with 40 byte password hashes instead of 16 byte
Now just knowing the hash isn't enough to let a cracker in.

--Simon ('cos old software is bad software)
Reply With Quote
  #3  
Old February 21st, 2005, 06:28 AM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 24th Plane (16500 - 16999 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 16,727 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 2 Days 19 h 22 m 42 sec
Reputation Power: 848
well, if we're going to list 4.1 features, i think one of the spiffiest is the GROUP_CONCAT function
Reply With Quote
  #4  
Old February 22nd, 2005, 09:13 AM
blockcipher blockcipher is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
  
Join Date: Mar 2003
Posts: 701 blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level)blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level)blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level)blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level)blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level)blockcipher User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 7 h 40 m 21 sec
Reputation Power: 55
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.

PHP5/MySQL/UTF-8
My Tech Blog
Reply With Quote
  #5  
Old June 21st, 2005, 12:15 AM
Sepodati's Avatar
Sepodati Sepodati is offline
Banned
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Dec 1999
Location: Afghanistan
Posts: 14,360 Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)Sepodati User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 69546 Folding Title: Intermediate FolderFolding Points: 69546 Folding Title: Intermediate FolderFolding Points: 69546 Folding Title: Intermediate FolderFolding Points: 69546 Folding Title: Intermediate Folder
Time spent in forums: 2 Months 3 Weeks 6 Days 2 h 26 m 30 sec
Reputation Power: 1606
Send a message via ICQ to Sepodati Send a message via Yahoo to 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).

---John Holmes...
Reply With Quote
  #6  
Old June 21st, 2005, 12:37 AM
ShytK ShytK is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2005
Posts: 154 ShytK User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 18 h 32 m 24 sec
Reputation Power: 4
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).

---John Holmes...


UTF-8 is super important for globalization.
Reply With Quote
  #7  
Old July 1st, 2005, 07:49 AM
tiguy4755's Avatar
tiguy4755 tiguy4755 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Location: Montréal
Posts: 147 tiguy4755 User rank is Sergeant (500 - 2000 Reputation Level)tiguy4755 User rank is Sergeant (500 - 2000 Reputation Level)tiguy4755 User rank is Sergeant (500 - 2000 Reputation Level)tiguy4755 User rank is Sergeant (500 - 2000 Reputation Level)tiguy4755 User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 2 h 30 m 8 sec
Reputation Power: 13
I'm just terribly affraid to switch from 4.0.20d to 4.1.x...

It looks like they made quite some change about Timestamp field and I'm not sure my applications will support it.
Reply With Quote
  #8  
Old October 24th, 2005, 04:45 PM
SimonGreenhill's Avatar
SimonGreenhill SimonGreenhill is offline
(retired)
Dev Shed God 11th Plane (10000 - 10499 posts)
  
Join Date: Dec 2003
Location: The Laboratory
Posts: 10,101 SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)  Folding Points: 4925 Folding Title: Novice Folder
Time spent in forums: 3 Months 3 Weeks 5 h 41 m 45 sec
Reputation Power: 1331
Facebook
Reply With Quote
  #9  
Old October 24th, 2005, 04:53 PM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 24th Plane (16500 - 16999 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 16,727 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 2 Days 19 h 22 m 42 sec
Reputation Power: 848
thanks simon -- subject changed
Reply With Quote
  #10  
Old October 28th, 2005, 01:24 PM
expert-database expert-database is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 37 expert-database Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 6 h 56 m 52 sec
Warnings Level: 10
Number of bans: 1
Reputation Power: 0
Lightbulb Now MySQL 5.0 production release available !!!
Hi,

Now is available the MySQL 5.0 for production, this is a great news for mysql friends.

Download Links
http://dev.mysql.com/downloads/mysql/5.0.html

MySQL 5.0 Features
http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html


Regards,
Reply With Quote
  #11  
Old October 31st, 2005, 03:10 PM
bauhsoj bauhsoj is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2005
Posts: 190 bauhsoj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 8 h 23 m 39 sec
Reputation Power: 3
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
Reply With Quote
  #12  
Old April 25th, 2006, 01:53 PM
axc97c axc97c is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2005
Posts: 3 axc97c User rank is Lance Corporal (50 - 100 Reputation Level)axc97c User rank is Lance Corporal (50 - 100 Reputation Level)axc97c User rank is Lance Corporal (50 - 100 Reputation Level) 
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.

Good luck

Adam
Comments on this post
r937 agrees: thanks for the great feedback and advice
Reply With Quote
  #13  
Old February 9th, 2007, 11:53 PM
ccalender ccalender is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2006
Posts: 166 ccalender User rank is Corporal (100 - 500 Reputation Level)ccalender User rank is Corporal (100 - 500 Reputation Level)ccalender User rank is Corporal (100 - 500 Reputation Level)ccalender User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 21 h 56 m 51 sec
Reputation Power: 6
I should note that MySQL recommends you dump and import your data when upgrading from 4.x to 5.0.

"MySQL recommends that you dump and reload your tables from any previous version to upgrade to 5.0."

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

So, simply dump all of your data with mysqldump from your old version. Perform your upgrade. Then, re-import your data into the new, upgraded version.

mysql -u root -p < dumpfile.txt
Reply With Quote