List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:February 9 2012 2:22pm
Subject:Re: conditional updating
View as plain text  
So, add your "other criteria" to the where clause, you failed to say
there were other conditions in your first email.

Sent from my iPad

On Feb 9, 2012, at 7:56 AM, william drescher <william@stripped> wrote:

> 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.
> Thanks
>
> bill
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
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