<no subject>
| From: | Don Johnson | Date: | Fri, 23 Feb 2001 18:27:44 +0000 |
| Subject: | <no subject> | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-41347@lists.php.net to get a copy of this message | ||
Yup. Go figure.
Don Johnson
> It works if you execute only the SELECT (without the UPDATE) ?
>
> Christian Reiniger
> LGDC Webmaster (http://sunsite.dk/lgdc/)
>
> On Friday 23 February 2001 16:57, Don Johnson wrote:
>> Yup, the data's correct. The new records all have the
>> DownloadedDateTime as '0000-00-00 00:00:00'
>
> >> SELECT * from db_table WHERE (DownloadedDateTime = '0000-00-00
> >> 00:00:00')
> >> UPDATE LOW_PRIORITY db_table SET
> >> DownloadedDateTime=CURRENT_TIMESTAMP WHERE (DownloadedDateTime =
> >> '0000-00-00 00:00:00')