Science, Tech, Math › Computer Science Limit - MySQL Command Share Flipboard Email Print Portra Images / Getty Images Computer Science PHP Programming MySQL Commands Tutorials Perl Python Java Programming Javascript Programming Delphi Programming C & C++ Programming Ruby Programming Visual Basic View More By Angela Bradley Computer Science Expert B.A, History, Eastern Oregon University Angela Bradley is a web designer and programming expert with over 15 years of experience. An expert in iOS software design and development, she specializes in building technical hybrid platforms. our editorial process Angela Bradley Updated March 18, 2017 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 Cite this Article Format mla apa chicago Your Citation Bradley, Angela. "Limit - MySQL Command." ThoughtCo, Aug. 26, 2020, thoughtco.com/limit-mysql-command-2693970. Bradley, Angela. (2020, August 26). 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 January 27, 2021). copy citation