Hi there,
On my laptop computer I was using the NT/2000 version of MySQL version .37 and I had a really nice multi-table select query that worked perfectly. Then I upgraded to the latest version .40 and now this query doesn't want to know. Admittedly I just copied the files from the old MySQL directory within MySQL\data into the new install.
Is this because I've migrated the databases across to the newer version of MySQL incorrectly or because I've the newer version of MySQL simply is more discriminating about multi-table selects or something else?
Any suggestions would be great, thanks
Owen
On my laptop computer I was using the NT/2000 version of MySQL version .37 and I had a really nice multi-table select query that worked perfectly. Then I upgraded to the latest version .40 and now this query doesn't want to know. Admittedly I just copied the files from the old MySQL directory within MySQL\data into the new install.
Is this because I've migrated the databases across to the newer version of MySQL incorrectly or because I've the newer version of MySQL simply is more discriminating about multi-table selects or something else?
Any suggestions would be great, thanks
Owen