Re: InnoDB Record Lock Command

[Rich Allen]

something along the lines of:

mysql> select * from <table> where <column> = <value> lock in share
> mode


On Sep 5, 2005, at 4:01 PM, Rich wrote:

> Hi there.
>
> I am looking for the syntax to lock individual records in an InnoDB  
> table.
> I can't seem to find anything outside of locking full tables.
>
>

Rich Allen
A kidney transplant saved my life, plese consider being an organ donor.