This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决
来源:互联网 发布:c语言的面向对象编程 编辑:程序博客网 时间:2024/06/06 01:14
原因是内层select语句带有limit子句。
原:
更新的时候的处理方式
update stu_score_childen A set A.fScore='-1' where A.fID in (select B.fID from stu_score_childen B limit 0,50 )
更改后的
update stu_score_childen A set A.fScore='-1' where A.fID in (select C.fID from (select B.fID from stu_score_childen B limit 0,50 ) C)
绕过带有limit的select就可以了
sql 查询的时候的处理方式
select sum(money) from event_bid a where a.id in (select c.event_bid_id from (select b.event_bid_id from lender_bonus b where b.bonus_id=25 and b.status='used' limit 300)c);
阅读全文