Re: how to lock record instead of lock tab?

It's simply the same:

select * from table where key_column = value for update.

With the for update clause you will lock all the rows selected.

=8-)
Karsten

Johnny schrieb:

> I need some helps about lock. Does anyone know how to lock record? I
> only know how to lock table (select * from table1 for update) but, it is
> too slow when there are a lot of transactions in the waiting queue.
>
> please help!
>
> Johnny
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 03 2000 - 02:35:29 CST