Re: Variable in LIMIT clause

[Joss]

Hi there,

I was actually looking for the same use of "LIMIT". I found a workaround, it might not be the best but it works.

create procedure limitTest(IN nbRowsToFetch int)
begin

SET SQL_SELECT_LIMIT = nbRowsToFetch;

select * from mytable;

SET SQL_SELECT_LIMIT = DEFAULT;

end //

But i'm still waiting to be able to use the "LIMIT" with n argument.....

Enjoy,

Joss.