Re: Variable in LIMIT clause

[Joss]

Markus Popp wrote:
> Looks interesting ;-), thanks!
>
> Is it possible to assign a variable to the second
> parameter of the LIMIT clause? Which can be used
> like
>
> SELECT ... LIMIT x, y
>
> That would be perfekt.
>
> Markus
>

Hi Markus,

Since I needed only a "LIMIT 0,n" use I haven't searched that much, but I guess you can still use your primary id with something like that:
CREATE PROCEDURE TestLIMIT` (IN offset INT, IN nbRowsToFetch INT)
BEGIN

SET SQL_SELECT_LIMIT = nbRowsToFetch;

SELECT * FROM myTable m
WHERE m.id > offset ;

SET SQL_SELECT_LIMIT = DEFAULT;

END\\

Otherwise you might like to play a bit with a CURSOR ;-)
Cheers,

Joss