Django删除除查询集的最后五个之外的所有内容

from django.db import models

class MyModel(models.Model):
    # 其他字段
    id = models.IntegerField(primary_key=True)

from django.db.models import OuterRef, Subquery

# 获取要删除的对象的 ID
objects_to_delete = MyModel.objects.exclude(
    id__in=MyModel.objects.order_by('-id')[:5]
).values('id')

# 使用 OuterRef 和 Subquery 删除对象
MyModel.objects.annotate(
    objects_to_delete=Subquery(objects_to_delete)
).filter(
    id__in=OuterRef('objects_to_delete')
).delete()