Error In Limit.

[Tian]

SELECT * FROM table_name

LIMIT 11, 20;

This query should have a 10 row(s) result but latest version 9.51 has 20row(s) result.

Any help? Thank you inn advance. 🙂

[ashwin]

Hi,

Quote:

SELECT * FROM table_name

LIMIT 11, 20;

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return.

Refer: http://dev.mysql.com/doc/refman/5.1/en/select.html#id772444

In this case, 11 specifies the offset of the first row to return and 20 specifies the maximum number of rows to return. Hence SQLyog returns 20 rows when you execute this query.

If you want only 10 rows to be retrieved then you can execute:

SELECT * FROM table_name

LIMIT 11, 10;

Regards,

Ashwin A

[Author]

Posts