本文介绍了在MySQL中限制SQL查询结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想限制我在MySQL中获取的行数.你能告诉我怎么做吗?
I would like to limit the amount of rows I fetch in MySQL. Can you show me how?
例如:
- 第一个查询,我只想检索前10,000条记录
- 第二个查询,我只想检索10,000-20,000之间的记录
等
推荐答案您要查找的术语是分页".不幸的是,这取决于SQL引擎的执行方式不同.
The term you're looking for is "pagination." Unfortunately, this is done differently depending on the SQL engine.
对于MS SQL Server,请参见以下堆栈溢出问题.
For MS SQL Server, see this Stack Overflow question.
自从您提到MySQL以来,它实际上非常简单:
Since you mentioned MySQL, it's actually quite simple:
SELECT [columns] FROM [a table] LIMIT 10000 SELECT [columns] FROM [a table] LIMIT 10000 OFFSET 10000第一个语句获取结果1-10,000,第二个语句获取结果10,001-20,000.
The first statement fetches results 1-10,000, and the second statement fetches results 10,001-20,000.
更多推荐
在MySQL中限制SQL查询结果
发布评论