解决语句
delete from table where
time >= (select time from table order by time desc limit 1 offset 10000 ) AND
time <= (select time from table order by time desc limit 1 offset 9000) ;
知识要点:
(1)要知道表内数据的排序后的第X条数据,可以用order by time limit 1 offset X-1;
意思是从1开始,偏移量为x-1,选的这一条数据即为第x条。
(2)系统默认升序排序(asc),即时间从最旧排到最新
这里用降序(desc),时间从最新排到最旧
(3)列名可以直接和表做比较进行筛选