At 11:15 -0800 2/18/05, Scott Klarenbach wrote:
I can't seem to pass in the LIMIT clause variables into a stored procedure
http://dev.mysql.com/doc/mysql/en/select.html says:
The LIMIT clause can be used to constrain the number of rows returned
by the SELECT statement. LIMIT takes one or two numer
I can't seem to pass in the LIMIT clause variables into a stored procedure
i.e.
Select * from table limit param1, param2;
I get a syntax error compiling the procedure, but when I replace
param1 and param2 with hard coded ints, ie, 10, 10, it compiles and
works fine.
Is this functionality not av
