Upgrade issues?

[cleanair4me46]

I have free version of MySQL 4.1.4 that is working great with many Web applications using ColdFusion.

Now we will be using free version of MySQL 5.0.45.
All the MySQL 4.1.4 will be migrated to 5.0.45.

Please advise any issues I will have when we migrate to the newer version of MySQL?

 

[r937]

mysql 5 is much stricter about adhering to sql standards

if you use "questionable" queries, they might stop working

for example...

  FROM table1, table2
LEFT JOIN table3
ON table3.foo = table1.bar

this will throw an error "unknown column table1.bar" even though table1.bar, of course, does exist

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon