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
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