This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决

原因是内层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就可以了

posted @ 2016-05-04 21:48  一切为了生存  阅读(5903)  评论(0)  编辑  收藏  举报