From: Reindl Harald
Date: February 9 2012 1:58pm
Subject: Re: conditional updating
List-Archive: http://lists.mysql.com/mysql/226768
Message-Id: <4F33D0FF.3000903@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig6687FA762C7B3836E775D153"

--------------enig6687FA762C7B3836E775D153
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 09.02.2012 14:55, schrieb william drescher:
> On 2/9/2012 8:22 AM, Johnny Withers wrote:
>> Update table set mydate=3Dnow() where mydate=3D'0000-00-00'; should do=
 it.
>  can't do that because the record is selected by other criteria.

so explain the criteria, show us the query

usually you do exatcly the same WHERE as for the select and add
and mydate=3D'0000-00-00'


--------------enig6687FA762C7B3836E775D153
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk8z0P8ACgkQhmBjz394AnmuFgCdG7SHBdJkONpoECDIhzEeehbO
FX0AoInVfGBCCkX8ZE2i6zS9KAu3fvex
=M3fJ
-----END PGP SIGNATURE-----

--------------enig6687FA762C7B3836E775D153--