解决sql语句无法识别运算符和通用的分页存储过程

代碼如下：

DELIMITER $$

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `ljm`.`pp.02`(pageindex INT ,pagesize INT)
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN
    DECLARE once INT;
   SET once:=(pageindex-1)*pagesize;
    SET @b=CONCAT('select * from person limit ',once,',',pagesize,'');
PREPARE hh FROM @b;
EXECUTE hh;
    END$$
DELIMITER ;