Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: MySQL 5 fully backwards compatible??

    Hello everybody

    I guess the subject title pretty much sums it up. I`ve had some problems getting MySQL 5 to work with an application I`ve written using MySQL 4.1 and Visual Basic 6. I haven`t changed anything in my application so I expected it pretty much to work!!

    Any ideas??

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    yes, i know of at least one application (can't recall which one it was, though) written with very sloppy SQL that throws errors in mysql 5

    mysql 5 is more stringent with regard to enforcing standards

    the scenario involves mixing table list syntax (e.g. FROM table1,table2,table3) with a LEFT OUTER JOIN | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2006
    Denver, Co. USA
    Here is a link to the changes between 4.x and 5.x -

    Only items on the incompatible changes list should cause you problems and require corrections to your logic.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts