java - Using MySQL's LIMIT without having a real limit -

i'm forced use mysql api in java requires limit parameter appended @ end of mysql query (e.g. limit x).

the problem fact don't need limit. should use integer.max_value parameter or caused unwanted side-effects?

as shown in mysql 5.7 reference manual (link) :

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 if forced use limit, use large number. example:

select * tbl limit 18446744073709551615; 

but according database structure, keep in mind limit query optimization