编程知识 cdmana.com

Django models 使用mysql的limit和offset功能

参考:
Specifying limit and offset in Django QuerySet wont work-StackOverflow
django官方文档

Use a subset of Python’s array-slicing syntax to limit your QuerySet to a certain number of results. This is the equivalent of SQL’s LIMIT and OFFSET clauses.

For example, this returns the first 5 objects (LIMIT 5):

Entry.objects.all()[:5]

This returns the sixth through tenth objects (OFFSET 5 LIMIT 5):

Entry.objects.all()[5:10]

Negative indexing (i.e. Entry.objects.all()[-1]) is not supported.

版权声明
本文为[zhfang]所创,转载请带上原文链接,感谢
https://segmentfault.com/a/1190000038623750

Scroll to Top