Re: Atomicity of a SELECT/UPDATE

2003-07-28 Thread William R. Mussatto
Andy Jackman said: > Hi, > I want to get any one of a number of rows that matches some criteria and > update it so that it is marked as 'mine'. How can I do this safely? > > Given something like this table: > > create table tbl_new ( > t_value varchar(16) primary key not null, > dt_used

Atomicity of a SELECT/UPDATE

2003-07-28 Thread Andy Jackman
Hi, I want to get any one of a number of rows that matches some criteria and update it so that it is marked as 'mine'. How can I do this safely? Given something like this table: create table tbl_new ( t_value varchar(16) primary key not null, dt_used datetime, l_pid int(9