List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 9 2012 1:58pm
Subject:Re: conditional updating
View as plain text  

Am 09.02.2012 14:55, schrieb william drescher:
> On 2/9/2012 8:22 AM, Johnny Withers wrote:
>> Update table set mydate=now() where mydate='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='0000-00-00'


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
conditional updatingwilliam drescher9 Feb
  • Re: conditional updatingMichael Dykman9 Feb
    • Re: conditional updatingwilliam drescher9 Feb
  • Re: conditional updatingJohnny Withers9 Feb
    • Re: conditional updatingwilliam drescher9 Feb
      • Re: conditional updatingReindl Harald9 Feb
        • Re: conditional updatingwilliam drescher11 Feb
      • Re: conditional updatingJohnny Withers9 Feb
        • Re: conditional updatingMichael Dykman9 Feb
          • Re: conditional updatingJohnny Withers9 Feb