Re: UPDATE technical question

2001-03-13 Thread Gerald L. Clark
No, Daniel. This operation is atomic ( can not be separated into smaller parts ). This is the correct way to do updates without user locking. The update thread will automatically lock the file during the update so no other process can modify the data. Daniel B I wrote: > > Hello, > if there is

UPDATE technical question

2001-03-13 Thread Daniel B I
Hello, if there is a MYSQL developer member (or guru), I would like to ask if there is possible that another query modify a field between the detection of a target row and the changes made to it, by an update query. Let me explain myself a little: suppose we have an update query, like this: UP