Melick's Blog

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