写mysql的时候提示
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
我的mysql是这样的:
select * from User where UID in(select HelpUID from SplitActivity where UserJoinActivityID =(select ID from UserJoinActivity where RandNumber='xotgf' limit 1) limit 6);
后来发现解决办法是先做一张临时表
改成这样
select * from User where UID in(select HelpUID from(select HelpUID from SplitActivity where UserJoinActivityID =(select ID from UserJoinActivity where RandNumber='xotgf' limit 1) limit 6) a);
问题解决