限制-MySQL命令

Definition: Limit is used to limit your MySQL query results to those that fall within a specified range. You can use it to show the first X number of results, or to show a range from X - Y results. It is phrased as Limit X, Y and included at the end of your query. X is the starting point (remember the first record is 0) and Y is the duration (how many records to display).

定义： Limit用于将您的MySQL查询结果限制在指定范围内。 您可以使用它显示前X个结果数，或显示X-Y个结果的范围。 它被表述为Limit X，Y，并包含在查询的末尾。 X是起点(记住第一条记录为0)，Y是持续时间(要显示多少条记录)。

Also Known As: Range Results

也称为：范围结果

Examples:

例子：

SELECT * FROM `your_table` LIMIT 0, 10

This will display the first 10 results from the database.

这将显示数据库的前10个结果。

SELECT * FROM `your_table` LIMIT 5, 5

This will show records 6, 7, 8, 9, and 10

这将显示记录6、7、8、9和10

翻译自: https://www.thoughtco.com/limit-mysql-command-2693970