On 23-May-06, at 1:37 PM, bitrunner wrote:
> For lock the record I use:
> select * from orders where id = 17 for update
>
> in this way lock the record with id = 17.
> If an other user demands the same record as I can understand that it
is lock?
> yes as long as autocommit is false this is true. In other words as
> long as you do this inside a transaction/
sorry but I dont have to understand.
How I can understand that there is an other user who lock the record?
Thanks.