以下文字转载自https://blog.csdn.net/wenqiangluyao/article/details/90206196

实现删除最近100条记录之前的所有数据

DELETE FROM car_base_state
WHERE state_id IN (
    SELECT state_id FROM (
      SELECT state_id
      FROM car_base_state
      ORDER BY currtime DESC, car_id DESC
      LIMIT 100, 100000
    ) a
)