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
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