Limit - MySQL Command

Businessman using laptop at creative office
Portra Images / Getty Images
Updated July 22, 2016

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).

Also Known As: Range Results

Examples: 

 SELECT * FROM `your_table` LIMIT 0, 10

This will display the first 10 results from the database.

 SELECT * FROM `your_table` LIMIT 5, 5

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

Format
mla apa chicago
Your Citation
Bradley, Angela. "Limit - MySQL Command." ThoughtCo, Jul. 22, 2016, thoughtco.com/limit-mysql-command-2693970. Bradley, Angela. (2016, July 22). Limit - MySQL Command. Retrieved from https://www.thoughtco.com/limit-mysql-command-2693970 Bradley, Angela. "Limit - MySQL Command." ThoughtCo. https://www.thoughtco.com/limit-mysql-command-2693970 (accessed October 21, 2017).