|
|
Posted by Paul Waring on 12/30/05 22:47
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
Navigation:
[Reply to this message]
|