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]