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
"UPDATE" with variablehsv24 Nov
  • Re: "UPDATE" with variableJohan De Meersman28 Nov