Re: MySQL execution order?
| From: | Christian Reiniger | Date: | Fri, 23 Feb 2001 17:09:06 +0000 |
| Subject: | Re: MySQL execution order? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-41336@lists.php.net to get a copy of this message | ||
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'
It works if you execute only the SELECT (without the UPDATE) ?
> >> 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')
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
..10001000110101011010101101011110111010113...????