php - MySQL LIMIT 不起作用可能与表结构有关吗？

Question

我有一个 MySQL 查询在机器 #1 上运行，但在 #2 上不起作用。

查询是:

SELECT
id, vehicle
FROM
requests
WHERE client_id = 8
AND
solved
IS NULL
AND requests_id IS NULL ORDER BY created
DESC LIMIT 10 OFFSET 10

如果我取出LIMIT 10 OFFSET 10它确实有效。

我想知道是否可能与表的配置有关，但我检查了两次，它们在两台服务器上基本相同......

Answer 1

正如您得出的结论并提出同样的问题

Sorry guys, just found out I haven't more than 10 entries. So that mean OFFSET won't paginate except you have that number of results? ~ @Filipe

快速入门

• PHP Limit Data Selections From MySQL
• LIMIT and OFFSET SQL Pagination

示例

1) $sql = "SELECT * FROM TableName LIMIT 20";

=> Will 将返回前 20 条记录。

2) $sql = "SELECT * FROM TableName LIMIT 10 OFFSET 15";

或者

$sql = "SELECT * FROM TableName LIMIT 15, 10";

=> 将仅返回 10 条记录，从记录 16 开始(OFFSET 15)