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
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