Mysql突破1093 delete where in 子查询限制
业务场景假装一张A表存储学生信息,三个字段,id,name,class 假装一张B表存储学生成绩,两个字段,id,score需求从A表中删除班级6中成绩低于66的学生原始SQLdelete from a where id in (select a.id from a INNER JOIN b ON a.id=b.id )错误信息:delete from a where id in (select a.id from a INNER JOIN b ON a.id=b.id )>