CREATE DEFINER=`XXXXX`@`%` PROCEDURE `producename`(IN in_page INT, IN in_count INT)
BEGIN
SET@str_where = '';
SET @start_index = (in_page-1)*in_count;
SET @end_index = in_page*in_count;
IF in_page >= 0 AND in_count > 0 THEN
SET @str_where = CONCAT('limit ', @start_index, ',', @end_index);
END IF;
SET @s = '';
IF @str_where <> '' THEN
SET @s = CONCAT('select * from tablename ', @str_where);
ELSE
select '1';
END IF;
PREPARE STMT FROM @s;
EXECUTE STMT;
END$$