MySQL Lists: mysql: Re: "UPDATE" with variable

List:	General Discussion	« Previous Message Next Message »
From:	Johan De Meersman	Date:	November 28 2011 11:43am
Subject:	Re: "UPDATE" with variable
View as plain text

----- Original Message -----
> From: "Halász Sándor" <hsv@stripped>
> 
> mysql> update address set membersince = (select membersince from
> address where memberid = 1258) where memberid = 1724;

IIRC, subselects are allowed, except for selects that reference the table you're updating.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
• "UPDATE" with variable	hsv	24 Nov
• Re: "UPDATE" with variable	Johan De Meersman	28 Nov