通用的分页存储过程

通用的分页存储过程：

DELIMITER $$

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `person`.`pro_person1`(page INT,roe INT)
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN
    DECLARE p INT;
    SET p:=(page-1)*roe;
    SET @sql=CONCAT('select*from person limit ',p,',',roe);
    PREPARE r FROM @sql;
    EXECUTE r;
    END$$

DELIMITER ;

调式：

    CALL v_person(1,5);