I found the following workout.
CREATE PROCEDURE GET_SOMETHING ( IN paraFrom INT , IN paraPage INT )
BEGIN SET @SQL = CONCAT("SELECT * FROM customers LIMIT ",paraFrom" , ",paraPage ) ; PREPARE stmt FROM @sql; execute stmt;END
Post a Comment
0 comments:
Post a Comment