MySQL: LIMIT 2,-1 -

$sql="select * `table_name` limit 1,-1"; 

why error report:

select * `table_name` limit 2,-1 

mysql said: documentation

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near '-1' @ line 1

from https://dev.mysql.com/doc/refman/5.0/en/select.html

the limit clause can used constrain number of rows returned select statement. limit takes 1 or 2 numeric arguments, must both nonnegative integer constants (except when using prepared statements).

to retrieve rows offset end of result set, can use large number second parameter. statement retrieves rows 96th row last:

select * tbl limit 95,18446744073709551615; 

so in case

$sql="select * table_name limit 1,18446744073709551615";