mysql - MySQL 中的 LIMIT 支持

Question

我正在尝试执行以下查询。

update share set holder = 22 where SHARE_ID IN (select SHARE_ID from SHARE WHERE holder=1 LIMIT 10)

当我尝试执行上述查询时出现此错误

#1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Answer 1

UPDATE  share
SET     holder = 22
WHERE   holder = 1
ORDER BY
        share_id
LIMIT 10

由于优化器问题，IN 子句不支持 LIMIT。