List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:February 9 2012 3:33pm
Subject:Re: conditional updating
View as plain text  
He did mention that there was another field he was updating, which
implies that the state of the date field was not the only condition.

 - michael

On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers <johnny@stripped> wrote:
> 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
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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