Do you speak English?
Posted
August 9, 2008 
Comments(0)
Comments(0) 
MySQL: passing limits as stored procedure parameters
Posted
June 23, 2008 Comments(1)
Comments(1) Unfortunately MySQL 5 (at least 5.0.15) does not allow using variables or procedure parameters with LIMIT.
Here is a workaround where SQL statement is generated inside stored procedure:
CREATE PROCEDURE GetList (limitStart INT, limitCount INT) BEGIN SET @SQL = CONCAT('SELECT ID, Name FROM `User` LIMIT ', limitStart, ', ', limitCount); PREPARE query FROM @SQL; EXECURE query; DEALLOCATE PREPARE query; END; |
