On 2/9/2012 8:58 AM, Reindl Harald wrote:
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='-00-00'; should do it.
can't do that because the record is selected by other criteria.
so explain the
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
will...@techservsys.com wrote:
I want to update a date field in a record. if the date in the field is
-00-00 I want to change it to the current
Update table set mydate=now() where mydate='-00-00'; should do it.
Sent from my iPad
On Feb 9, 2012, at 7:15 AM, william drescher will...@techservsys.com wrote:
I want to update a date field in a record. if the date in the field is
-00-00 I want to change it to the current date. I
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-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:
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='-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
On 2/9/2012 8:18 AM, Michael Dykman wrote:
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
Thank you very much !
bill
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
will...@techservsys.com wrote:
I want to update a date field in a
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 will...@techservsys.com wrote:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where
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 joh...@pixelated.net wrote:
So, add your other criteria to the where clause, you failed to say
there
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 mdyk...@gmail.com wrote:
He did mention that there was another field he was updating, which
implies that the state of the