xiaowuguiya的博客

解决语句delete from table wheretime >= (select time from table order by time desc limit 1 offset 10000 ) ANDtime <= (select time from table order by time desc limit 1 offset 9000) ;知识要点：（1）要知道表内数据的排序后的第X条数据，可以用order by time limit 1 offset X-1；意思是从1