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就可以了
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步