Mysql - Uses of Offset ?

[santhanalakshmi]

What is the purpose of OFFSET in mysql ?

   mysql>select * from info oFFSET 3 ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3' at line 1

[chathura86]

http://www.petefreitag.com/item/451.cfm

[Atli]

Hey.

Also see the part about LIMIT in the Manual (12.2.8. SELECT Syntax)

Basically, the MySQL syntax to LIMIT the rows a result set will return goes:

SELECT ... LIMIT x, y

Where "x" is the number of rows you want returned and "y" is the offset. (Offset meaning; the number of rows to remove from the top of the list.)
For example, if you have a 100 rows in the original result set a "LIMIT 10, 20" would return rows #21 through #30. That is; 10 rows starting after #20.

For compatibility with PostgreSQL, you can optionally replace the comma in the LIMIT syntax with the OFFSET keyword.

SELECT ... LIMIT x OFFSET y

However, this is optional. You don't need to do this unless you plan on building PostgreSQL compatible queries.

[santhanalakshmi]

hi,
I got it....thanks for your response