MySQL Forums
Forum List  »  Newbie

Re: Update syntax? Why does one work and the other not?
Posted by: David Fells
Date: May 02, 2005 03:17PM

You would have to alias tab1 in the subquery.

update tab1 set col1 = (select col1 from tab1 AS t1 where key2 = somevalue)
where col1 = key1

Options: ReplyQuote


Subject
Written By
Posted
Re: Update syntax? Why does one work and the other not?
May 02, 2005 03:17PM


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.