Re: Multiple Row Locking

Steve Raftery wrote:
> I am trying to lock multiple rows of data in a single table without
> having to lock the entire table. If we have a table that has a column
> sales_group. There may be thousands of entries in the table but only
> 50 or 100 that have the sales group value of 2. Is there a way to
> lock all the rows of the table where sales_group = 2 without locking the
> entire table?

SELECT ... FROM table WHERE sales_group = 2 FOR UPDATE;

Well detailed in the manual. You DID read the manual, didn't you?

ALL unsolicited commercial e-mail is unwelcome at this site. Keep your advertising to yourself!

-- 
Bill Meahan  wmeahan_at_ford.com
Ford Motor Company -- End User Support - North America
Not an official statement of Ford Motor Company or anyone else
except the author.