Mysql retrieve all rows with limit

Question

I want to retrieve all rows of a particular user with limit 0,x..

So i just want to ask is there any way to retrieve all rows in mysql without calling a method which returns count(id) of x& without making an overload of existing function which does not have limit at all in query & withour string.Relace() functionality.

As internally mysql is might using this when we check show all check Box then all rows of taht table are displayed

Answer 1

If you want to retrieve all rows, you just don't use the LIMIT clause..

Answer 2

Simple solution is sending int's max range to method i.e 2147483647 as it is same in both mysql & c# (4 bytes) can use int.MaxValue . see references http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html,http://msdn.microsoft.com/en-us/library/5kzh1b5w%28VS.80%29.aspx .