Delete all records except latest 1000

In my opinion you want to use skip. Something like this.

DB::table('table')->latest()->skip(1000)->delete();

Thanks for pointing me in the right direction with skip. Although there are 2 bugs in the code you provided (at least for mysql); I will point them out for others stumbling across this question.

1. You can't use skip without a take
2. You cant delete with a skip/take (some mysql limitation)

Unfortunately these 2 limitations made me use 2 queries and a loop! I'm sure there is a better way of doing this.

$count = Table::count();

$deleteUs = Table::latest()->take($count)->skip(1000)->get();

foreach($deleteUs as $deleteMe){
            Table::where('id',$deleteMe->id)->delete();
        }

Slightly improved version. Removes query from loop.

$ids = [];
$count = Table::count();

$deleteUs = Table::latest()->take($count)->skip(1000)->get();

foreach($deleteUs as $deleteMe){
            $ids[] = $deleteMe->id;
        }

Table::destroy($ids);

Or maybe this.

$deleteUs = Table::latest()->take($count)->skip(1000)->get()->each(function($row){ $row->delete(); });

is 1000 fixed number or is approximate ok? I'm just thinking that with deleted records, this might not work exactly

if you are using auto incrementing ids

    $top = Model::latest()->pluck('id');

    Model::latest()->where('id', '<', $top-1000)->delete();

Make sure you test it on some unwanted data!

Basically, find the highest ID then delete everything with an ID that is less than the current ID minus 1000 (without looping over the entire set)