mysql通用的分页存储过程`

DELIMITER $$ 
CREATE 
    PROCEDURE `test`.`P_paging1`(IN pagesize INT,IN myrows INT) 
    BEGIN 
SET @name2=CONCAT('select * from person limit ',(pagesize-1)*myrows,',',myrows,'  ');
PREPARE r FROM @name2;
 EXECUTE   r; 
    END$$


DELIMITER ;


#调用存储过程
CALL `test`.`P_paging1`(2,5);