MySQL Forums
Forum List  »  Oracle

update with select in MYSQL
Posted by: Dudi Naim
Date: January 22, 2006 09:51AM

How this SQL synrax in MYSQL

Update SYS_CONFIG_DATA set B_DATA = (select B_DATA from SYS_CONFIG_DATA where VID = 430 and SERVER_ID = 42) where VID = 430 and SERVER_ID = 924



Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
update with select in MYSQL
195414
January 22, 2006 09:51AM
72259
January 25, 2006 07:42AM
65170
January 25, 2006 09:19AM
65208
January 27, 2006 12:44PM
46776
September 27, 2006 09:44PM
33119
May 13, 2009 02:51PM


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.