List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:February 9 2012 9:25pm
Subject:Re: conditional updating
View as plain text  
It implied to me there were two fields to update based on the date
being a given value. Read it how you like.

Sent from my iPad

On Feb 9, 2012, at 9:34 AM, Michael Dykman <mdykman@stripped> wrote:

> 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.
>
> --
> 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