MySql offset query not working

Question

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;

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

Abhik Chakraborty · Accepted Answer · 2015-05-19 07:24:25Z

3

The syntax is wrong and its

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

Note that limit without order by is having no meaning.

SELECT id FROM nameTable order by id limit 10 OFFSET 10

answered May 19, 2015 at 7:24

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shafizadeh Over a year ago

ow i see, then if i want to use OFFSET, i should use ORDER BY and LIMIT too, right ?

Abhik Chakraborty Over a year ago

Well mysql does not preserve ordered data while returning data , so its better to use order by clause for a meaning full result. You may use different version of limit something as limit 0,10 or limit 10 offset 0 are same.

Collectives™ on Stack Overflow

MySql offset query not working

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related