MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: update inside a select
Posted by: Peter Brawley
Date: March 25, 2015 11:34AM

The syntax you're looking for is ...

update a join b on ... join c on ... set a.foo=...

See the manual page for Update.



Edited 1 time(s). Last edit at 03/27/2015 10:13AM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
update inside a select
John Biddulph
March 25, 2015 04:27AM
Re: update inside a select
Peter Brawley
March 25, 2015 11:34AM
Re: update inside a select
Peter Brawley
March 27, 2015 10:15AM
Re: update inside a select
John Biddulph
March 27, 2015 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.