1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Limit - MySQL Command


Woman working on computer at home
Muriel de Seze/Digital Vision/Getty Images
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
 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
  1. About.com
  2. Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. Limit: Definition and Examples - PHP / MySQL

©2014 About.com. All rights reserved.