Using limit with update in mysql [duplicate]

Question

I am trying to use limit with update in mysql but is giving an error

Error: MySQL Error: Incorrect usage of UPDATE and LIMIT

update table1
JOIN table2 
  ON SUBSTRING_INDEX(table1.HOST, '.',1)= SUBSTRING_INDEX(table2.HOST, '.', 1)
set table1.portalId = table2.portalId
limit 2;

Well, the documentation clearly states that "For multiple-table syntax, ORDER BY and LIMIT cannot be used." (dev.mysql.com/doc/refman/8.0/en/update.html) — Mureinik
– Mureinik, Commented Jun 28, 2018 at 20:38

Uueerdo · Accepted Answer · 2018-06-28 20:38:16Z

0

However, you cannot use ORDER BY or LIMIT with a multiple-table UPDATE.

From the official reference

It's also the exact text shown when you search google for "mysql update limit".

answered Jun 28, 2018 at 20:38

Uueerdo

16k1 gold badge19 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BlackMarker · Accepted Answer · 2018-06-28 20:43:37Z

0

LIMIT can be used with UPDATE but with the row count only. You can try doing an inner select which may be more complicated but you may just be able to use your desired limit in there

MYSQL Reference

answered Jun 28, 2018 at 20:43

BlackMarker

13912 bronze badges

Collectives™ on Stack Overflow

Using limit with update in mysql [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related