List:General Discussion« Previous MessageNext 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 variablehsv24 Nov
  • Re: "UPDATE" with variableJohan De Meersman28 Nov