Thursday, February 6, 2014

How to get all results without the first row from a MySQL table

To exclude first row you have to use MySQL limit clause.

select * from table limit 1, 10000000

You can pass 2 values to limit clause first one is the starting row. Row index start with 0 so you have to put 1 to remove first row. Second parameter is the number of result u need to retrieve. Put a number that is larger than max rows of table.

No comments:

Post a Comment