我编写了以下查询来仅删除 100 行：
delete T1 from table1 T1
INNER table2 T2 ON
T1.column1 = T2.column1
where T2.id IN(select id from table2 where date >= '2001-01-01' limit 100)
我收到一个错误 This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
您可以使用 join 而不是 in delete T1 from table1 T1 INNER table2 T2 ON T1.column1 = T2.column1 JOIN (select id from table2 where date >= '2001-01-01' limit 100) AS temp On temp.id =T2.id
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句