Re: SELECT?
| From: | Paul Waring | Date: | Fri, 30 Dec 2005 20:47:10 +0000 |
| Subject: | Re: SELECT? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-228046@lists.php.net to get a copy of this message | ||
On 12/30/05, Richard Lynch <ceo@l-i-e.com> wrote:
> The suggestions so far are good, but watch out for this:
>
> If you do one record at a time, and are using LIMIT, and then
> something gets inserted into the original table...
>
> Boom!
You could always lock the tables whilst performing the update - not
very useful if the database has to be up all the time but it's
probably the safest way of doing it.
Paul
--
Data Circle
http://datacircle.org