However, one issue is with MySQL, the version currently included (5.0.15) actually has a few nasty bugs in it! Namely joins don't recognise others tables, so a query like:
- Code: Select all
SELECT *
FROM table1 t1, table2 t2
LEFT JOIN table3 t3 ON t3.id = t1.user
WHERE t1.id = t2.id
Will fail with an error of "Unknown column 't1.user' in 'on clause'".
Now, as far as I'm aware this syntax hasn't changed, and it worked fine in v4.0.11 of MySQL which I had before.
Anyway, I'm assuming it's a bug, and MySQL v5.0.21 is now out and considered the current stable version, so I'd like to install that, however xampp seems to have all the files in loads of custom locations, so I have no idea what I'm supposed to do in order to upgrade them.
Any help to do this, or a new release of Xampp with the new version would be awesome!
Thanks!