Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,196
    Rep Power
    4279

    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
    Last edited by r937; September 27th, 2011 at 07:34 AM.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  2. #2
  3. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
    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)
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,196
    Rep Power
    4279
    well, if we're going to list 4.1 features, i think one of the spiffiest is the GROUP_CONCAT function

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Mar 2003
    Posts
    704
    Rep Power
    61
    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
  8. #5
  9. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    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 [phpnet=htmlentities]htmlentitites()[/phpnet] (when using PHP, obviously).

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2005
    Posts
    154
    Rep Power
    10
    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 [phpnet=htmlentities]htmlentitites()[/phpnet] (when using PHP, obviously).

    ---John Holmes...
    UTF-8 is super important for globalization.
  12. #7
  13. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Location
    Montréal
    Posts
    147
    Rep Power
    19
    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.
  14. #8
  15. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
  16. #9
  17. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,196
    Rep Power
    4279
    thanks simon -- subject changed
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  18. #10
  19. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    37
    Rep 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,
  20. #11
  21. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2005
    Posts
    278
    Rep Power
    10
    My main interest in version 5.0 is speed the improvements made to SELECT queries using OR.

    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
  22. #12
  23. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2005
    Posts
    3
    Rep 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
  24. #13
  25. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2006
    Posts
    332
    Rep Power
    41
    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
  26. #14
  27. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jan 2006
    Location
    India
    Posts
    857
    Rep Power
    548
    The latest version available now is MySql 5.2.3 . Subject may be altered, if needed.
    Akash Dwivedi
    "Whatever the mind can conceive and believe, the mind can achieve."
    Feel good..


  28. #15
  29. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2006
    Posts
    332
    Rep Power
    41
    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:

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

    (as of May 19, 2007)
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo