mysql更新(in)多于1行

Question

UPDATE tbl_bonuses AS B 
INNER JOIN tbl_member AS V 
ON B.recepient_code = V.user_id 
SET B.points = B.points + 15, B.ctr = B.ctr + 15
WHERE user_id IN (SELECT user_id from tbl_member LIMIT 10);

错误:

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

有没有其他方法可以在不使用 (in) 的情况下使用多个参数进行多次更新？

Answer 1

将子查询包装在派生表中

UPDATE tbl_bonuses AS B 
INNER JOIN tbl_member AS V 
ON B.recepient_code = V.user_id 
SET B.points = B.points + 15, B.ctr = B.ctr + 15
WHERE user_id IN (SELECT user_id FROM (
                                       SELECT user_id from tbl_member LIMIT 10
                                      ) t 
                 );