Mysql学习mysql select查询中使用limit的例子

/*
mysql> select * from Product;
+-----------+------------+----------------------+-------+
| ProductID | Name       | Description          | Price |
+-----------+------------+----------------------+-------+
|         1 | Java       | Java Demo Code       |     6 |
|         2 | Swing      | Swing Demo Code      |     7 |
|         3 | C#         | C# Demo Code         |     4 |
|         4 | JavaScript | JavaScript Demo Code |     3 |
|         5 | SQL        | SQL Demo Code        |     8 |
|         6 | Struts     | Struts Demo Code     |     9 |
+-----------+------------+----------------------+-------+
6 rows in set (0.00 sec)MYSQL利用

mysql> /* Browse Products */
mysql> SELECT ProductID, Name
    -> FROM Product
    -> ORDER BY ProductID
    -> LIMIT 3,4;
+-----------+------------+
| ProductID | Name       |
+-----------+------------+
|         4 | JavaScript |
|         5 | SQL        |
|         6 | Struts     |
+-----------+------------+
3 rows in set (0.00 sec)MYSQL利用

*/
/* Create Database */ 
Drop TABLE Product;MYSQL利用

CREATE TABLE Product (
    ProductID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
    Name VARCHAR(50) NOT NULL,
    Description VARCHAR(255) NOT NULL,
    Price DECIMAL NULL
) Type=InnoDB;
 
 
/* Insert Data */
INSERT INTO Product (Name, Description, Price) VALUES ('Java',
                                                       'Java Demo Code',
                                                       5.99 );
INSERT INTO Product (Name, Description, Price) VALUES ('Swing',
                                                       'Swing Demo Code',
                                                       6.99 );
INSERT INTO Product (Name, Description, Price) VALUES ('C#',
                                                       'C# Demo Code',
                                                       3.99 );
INSERT INTO Product (Name, Description, Price) VALUES ('JavaScript',
                                                       'JavaScript Demo Code',
                                                       2.99 );
INSERT INTO Product (Name, Description, Price) VALUES ('SQL',
                                                       'SQL Demo Code',
                                                       7.99 );
INSERT INTO Product (Name, Description, Price) VALUES ('Struts',
                                                       'Struts Demo Code',
                                                       8.99 );
 MYSQL利用

select * from Product;MYSQL利用

/* Browse Products */
SELECT ProductID, Name
FROM Product
ORDER BY ProductID
LIMIT 3,4;MYSQL利用