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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to