MySQL – Select From Certain Record To The Last Record

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 96, 18446744073709551615;


18446744073709551615 is 2^64-1 for those who were wondering. You may want to watch out because you won’t be able to store this value in an 32 bit integer. You have to make sure you store this as a string to ensure compatibility

18446744073709551615 is the maximum value of unsigned BIGINT




413 Request Entity Too Large

you have set necessary PHP configuration to accept large file upload but still get this error. This error is thrown by Nginx, to resolve just set the client_max_body_size variable  the server block, the size should be in Megabytes. eg:

client_max_body_size 200M;