List:General Discussion« Previous MessageNext Message »
From:Markus K√§llander Date:June 9 2004 4:25pm
Subject:UPDATE...WHERE ... IN (SELECT...)
View as plain text  
Hi all,
 
Can someone tell me what is wrong with this statement? 
 
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
 
I use MySQL 3.23.49.
 
Thanks
Markus Källander

Thread
UPDATE...WHERE ... IN (SELECT...)Markus K√§llander9 Jun
RE: UPDATE...WHERE ... IN (SELECT...)Victor Pendleton9 Jun
RE: UPDATE...WHERE ... IN (SELECT...)Michael Young9 Jun
Re: UPDATE...WHERE ... IN (SELECT...)Josh Trutwin9 Jun
RE: UPDATE...WHERE ... IN (SELECT...)Laercio Xisto Braga Cavalcanti9 Jun