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)
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
