mysql删除指定数量的数据

delete from table_temp where ID in 
(select t.ID from (select ID from table_temp  limit 1001,2000) as t);

table_temp 为表名;

ID为主键;