mysql当中limit和in不能同时使用。
再加一层select就可以绕过limit和in不能一起使用的尴尬场景了!
原SQL:
SELECT user_id FROM tb_user WHERE user_id not in (
SELECT user_id FROM tb_order ORDER BY value DESC LIMIT 0,50
)
提示:1235 - This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’
调整:
SELECT user_id FROM tb_user WHERE user_id not in (
SELECT t.user_id FROM (
SELECT user_id FROM tb_order ORDER BY value DESC LIMIT 0,50
) as t
)
加粗字体为改动部分