test mjom wrote:
Hi, i'm beginning with SQLite and it seems that the keyword LIMIT is
not supported on an UPDATE statement.
Does anybody would have a workaround to update only the very first
row matching the search criteria ? Ex :
create table tbl1 ( id integer primary key autoincrement, ref
integer, sts varchar(16));
insert into tbl1 (ref,sts) values (10, 'ready' );
insert into tbl1 (ref,sts) values (20, 'ready' ); insert into tbl1
(ref,sts) values (30, 'ready' );
update tbl1 set sts='busy' where sts='ready' ORDER BY ref DESC LIMIT 1;
=> i would like to have only the third record (30,'busy') updated.
I should clarify that my SQL is slightly different than Darrel's. By
using the primary key, which is guaranteed to be unique, I am certain
that only one record will be updated. Darrel's statement will update all
the records that have the same value in the ref column. This is not
necessarily the same thing.
Dennis Cote
