在MySQL中限制SQL查询结果 [英] Limit SQL query result in MySQL

问题描述

我想限制我在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查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！