SEE BELOW FOR UPDATE TO THIS POST
I'm new to MySQL. I wanted to update TableA from TableB if a field in each matched. I could find no way to do this in MySQL 3. Then I discovered that 4.0.13 allows multiple-table UPDATE, eg
UPDATE TableA, TableB
SET TableA.stuff = TableB.stuff
WHERE TableA.id = TableB.id;
I uninstalled MySQL 3 and installed 4.0.13. (I did not update any ODBC drivers etc as I've no idea if this is needed. I also did not run mysql_fix_privilege_tables as there is no easy way on Windows and I hoped the reinstall would make it unnecessary).
But SQLyog still gives an error 1064 with the above syntax.
If SQLyog can't do this, is there some other way of doing the update I need? Seems a pretty basic coding requirement.
UPDATE: The above post has not yet appeared but I presume it is in transit.
It DOES work! Turns out there was a missing ; in my SQL window, some way above my code! 🙁
