From: Johan De Meersman
Date: November 28 2011 11:43am
Subject: Re: "UPDATE" with variable
List-Archive: http://lists.mysql.com/mysql/226377
Message-Id: <56f68151-8c79-4046-b409-7c42ac20db79@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

----- Original Message -----
> From: "Hal=C3=A1sz S=C3=A1ndor" <hsv@stripped>
> 
> mysql> update address set membersince =3D (select membersince from
> address where memberid =3D 1258) where memberid =3D 1724;

IIRC, subselects are allowed, except for selects that reference the table y=
ou'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