Re: [sqlite] An update with LIMIT ?

> > Is there a way I could use LIMIT in an update? > > No, but if your table has a single-column primary key, > called PK for example, you can get the same result with > > update Address set Retrieved = 1 > where PK in (select PK from Address >where Group = 'a' limit 5) Would y

Re: [sqlite] An update with LIMIT ?

> Is there a way I could use LIMIT in an update? No, but if your table has a single-column primary key, called PK for example, you can get the same result with update Address set Retrieved = 1 where PK in (select PK from Address where Group = 'a' limit 5) If your primary key c

Re: [sqlite] An update with LIMIT ?

On Fri, June 11, 2004 12:50, Jay Macaulay said: > Hi all, > > I have a database where I'm selecting rows using LIMIT. Is there a way I > could use LIMIT in an update? For example right now I do: > > SELECT * FROM address WHERE group="a" LIMIT 5; > > Is there some way I could instantly update thos

[sqlite] An update with LIMIT ?

Hi all, I have a database where I'm selecting rows using LIMIT. Is there a way I could use LIMIT in an update? For example right now I do: SELECT * FROM address WHERE group="a" LIMIT 5; Is there some way I could instantly update those 5 I retrieved? Something like: UPDATE address SET retr