MySql 偏移查询不起作用 [英] MySql offset query not working

问题描述

我有 MySql Workbench 6.2CE(希望这有帮助..)我正在尝试这样的偏移查询:

I have MySql Workbench 6.2CE (hope this helps..) And I'm trying to an offset query like this :

SELECT id FROM nameTable OFFSET 10 ROWS; 

但是它给了我一个语法错误 10 : 在这个位置不是一个有效的输入.有人知道问题吗?谢谢！

But it give me a syntax error on the 10 : is not a valid input in this position. Anyone knows the problem ?Thank you!

推荐答案

语法错误及其

select * from table order by someid
[LIMIT {[offset,] row_count | row_count OFFSET offset}]

https://dev.mysql.com/doc/refman/5.0/en/select.html

请注意，没有 order by 的 limit 是没有意义的.

Note that limit without order by is having no meaning.

SELECT id FROM nameTable order by id limit 10 OFFSET 10

这篇关于MySql 偏移查询不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！