Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
186 views
in Technique[技术] by (71.8m points)

mysql - Database: SQL Pagination?

I'm using MySQL.

I want to limit the amount of rows fetched from the database. I have a SQL statement that returns 10,000 records which are all relevant to the search.

SELECT colA, colB, colC
FROM xyzTable
WHERE ...
ORDER BY colA

I know how to use the TOP statement to return the TOP x number of rows fetched but how do I fetch rows rows in the middle of the search result, for example, rows 50-100?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

MySQL's limit clause makes this easy:

SELECT cols
FROM table
LIMIT offset, rowcount

In your case:

LIMIT 49, 50 -- skip rows 0-49, grab the next 50

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...