Mysql Limit

Mysql Limit is used to limit your query result to those which fall within a specified range.

Mysql Limit

Mysql Limit

     

Mysql Limit is used to limit your query result to those which fall within a specified range.

The Query below  X -Y show a range from X-Y results. It is also called Limit X,Y. The X is the first record and Y is the number of records that you want to display. 

SELECT * FROM `your_table` LIMIT  X,Y;

Understand with Example

The Mysql Limit Tutorial describe you an elaborative example to return those records that falls within a specified range. To begin with this example, we need to create a table 'employee1'.The create table statement is used to create a table 'employee1' with your required field name and its datatype respectively.

 

Query to Create Table named employee1:

mysql>CREATE TABLE employee1 (              
         ->    Empid int(10),         
         ->    Empname varchar(60),   
         ->    date date 
         ->  );

Query to insert data into Table named employee1:

Once your table 'employee1' is created ,the insert into adds the records into table 'employee1'.

mysql>insert into employee1 values(01,'Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(03,'vineet','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(04,'Amit','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-23');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'suman','2008-12-25');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(01,'AAA',' 2008-12-03');
Query OK, 1 row affected (0.02 sec)

Query to view data of  Table named employee1:

To view the records from table 'employee1' we use select query that return the records from table 'employee1'.

mysql> select * from employee1;

Output:-

+-------+---------+------------+
| Empid | Name    | DOB        |
+-------+---------+------------+
| 1     | Girish  | 2008-12-20 |
| 2     | Komal   | 2008-12-21 |
| 3     | vineet  | 2008-12-21 |
| 4     | Amit    | 2008-12-20 |
| 2     | Komal   | 2008-12-23 |
| 2     | Sandeep | 2008-12-24 |
| 2     | suman   | 2008-12-25 |
| 1     | AAA     | 2008-12-03 |
+-------+---------+------------+
8 rows in set (0.00 sec)

Query to view data of  Table named employee1 using Limit:

The Query limit 2,2 given below will show you the record between 3 and 4

mysql> select * from employee1 limit 2, 2;

Output:-

+-------+--------+------------+
| Empid | Name   | DOB        |
+-------+--------+------------+
| 3     | vineet | 2008-12-21 |
| 4     | Amit   | 2008-12-20 |
+-------+--------+------------+
2 rows in set (0.00 sec)