Re: [SQL] UPDATE & LIMIT together?

2002-09-03 Thread tp
queue). My query now looks like: UPDATE queue SET state=20 WHERE (id) IN (SELECT id FROM queue LIMIT 10) -tp Bruce Momjian([EMAIL PROTECTED])@Wed, Aug 28, 2002 at 01:01:36PM -0400: > > You have to use a subquery returning the tables primary key to the > UPDATE: > > UPDA

[SQL] UPDATE & LIMIT together?

2002-08-28 Thread tp
locking? -tp msg07235/pgp0.pgp Description: PGP signature