problem with update using join

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I do not understand what is wrong with my query:

mysql> update prices,prices_tmp set
where prices.isbn = prices_tmp.isbn;

ERROR 1064: You have an error in your SQL syntax near 'prices_tmp set where prices.isbn = prices_tmp.' at
line 1

it seems to follow the sample code I have seen:

mysql> UPDATE cds, artists
    -> SET cds.title = 'The Funkship Odyssey', artists.Artist = 'George
    -> WHERE (artists.artistID = cds.artistID) AND (cds.cdID = '2');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Re: problem with update using join

Quoted text here. Click to load it

What version of MySQL are you using?  Multi-table updates were implemented
in MySQL 4.0.4, according to the documentation.

Bill K.

Re: problem with update using join

i discovered I am running an older version of mysql

Site Timeline