How can I LIMIT rows updates in MySQL if more than one table is involved?

Posted by Taz on Stack Overflow See other posts from Stack Overflow or by Taz
Published on 2010-04-26T10:32:32Z Indexed on 2010/04/26 11:13 UTC
Read the original article Hit count: 229

Filed under:
|
|

I am trying to run an UPDATE query

UPDATE ner.nerdataset, ner.shortabstracts
SET    ner.nerdataset.ShortAbstract=ner.shortabstracts.ShortAbstract
WHERE  ner.shortabstracts.Resource=ner.nerdataset.ResourceURI
LIMIT  10;

As MySQL does not allow the use of LIMIT when more than one table is involved in UPDATE what else can be done to limit this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql