《MysqL学习MysqL select查询中使用limit的例子》要点：
本文介绍了MysqL学习MysqL select查询中使用limit的例子，希望对您有用。如果有疑问，可以联系我们。
本节内容：
MysqL select查询中limit的用法MysqL利用
/*
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,Price) VALUES ('Swing',
'Swing Demo Code',
6.99 );
INSERT INTO Product (Name,Price) VALUES ('C#',
'C# Demo Code',
3.99 );
INSERT INTO Product (Name,Price) VALUES ('JavaScript',
'JavaScript Demo Code',
2.99 );
INSERT INTO Product (Name,Price) VALUES ('sql',
'sql Demo Code',
7.99 );
INSERT INTO Product (Name,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利用
《MysqL学习MysqL select查询中使用limit的例子》是否对您有启发，欢迎查看更多与《MysqL学习MysqL select查询中使用limit的例子》相关教程，学精学透。编程之家PHP学院为您提供精彩教程。