how to specify only start index in LIMIT in MySQL select query?

Question

I want to select the records from the table starting from 3rd row. How this can achieved with LIMIT?

Answer 1

Like this:

SELECT * FROM MyTable LIMIT 2, 18446744073709551615;

(The offset is zero-based)

Answer 2

From the MySQL Documentation:

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

Answer 3

i am giving syntax

SELECT field1, field2,...fieldN table_name1, table_name2... [WHERE Clause] [OFFSET M ][LIMIT N]