> 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
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
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
Hello Stephen,
On Jun 11, 2004, at 12:18, Drew, Stephen wrote:
The problem with having separate pointers is that the threads
themselves do
not have any idea of the database they will be using, which is wrapped
in
shared classes. The threads are merely worker threads that do arbitrary
jobs.
I
4 matches
Mail list logo