Hi,
Tim Johnson wrote:
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the following:
ERROR 1064 (00000): You have an error in your SQL syntax near 'FRED SET
wine_list.wine_ID=FRED.WMJ_ID WHERE wine_list.wine_ID=FRED.wine_ID' at line 1
Any ideas on how to make it work? Pointers to error codes would be helpful,
also.
Multi-table updates aren't supported until... um... 4.0.8 I think. Can't quite
remember.
I think the best way is to do an INSERT..SELECT into a temp table, then INSERT..SELECT
from the temp table back to where you want the data to live.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]