博客

MySQL limit分页语句用法

select * from table limit 5; --返回前5行  
  
select * from table limit 0,5; --同上，返回前5行  
  
select * from table limit 5,10; --返回6-15行 

MySQL通用的分页存储过程

DELIMITER $$  
  
CREATE  
    /*[DEFINER = { user | CURRENT_USER }]*/  
    PROCEDURE `t204`.`pro_1`(pageindex INT,rowss INT)  
    /*LANGUAGE SQL  
    | [NOT] DETERMINISTIC  
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }  
    | SQL SECURITY { DEFINER | INVOKER }  
    | COMMENT 'string'*/  
    BEGIN  
SET @pro=CONCAT('select * from person limit ',(pageindex-1)*rowss,',',rowss);  
PREPARE pro FROM @pro;  
EXECUTE pro;  
    END$$  
  
DELIMITER ;  

调用

CALL pro_1(1,5);