最基础的mysql分页存储过程

DELIMITER $$

 

CREATE PROCEDURE `page_select`(tablenamevarchar(200),pageindex int,pagesize int,out totalcount int)

-- tablename 查找条件 -- pageindex 当前页码 --pagesiz 每页记录数 -- totalcount 标志：统计数据/输出数据

BEGIN

         declarestartindex int default 0;

         declaresqlstr varchar(1000);

        

         set@startindex = pageindex*pagesize;

         set@size = pagesize;

         set@sqlstring = concat(

         'selectsql_calc_found_rows * from ',

         tablename,

         'limit ',

         @startindex,

         ',',

         @size,

         ';');

         preparesqlstr from @sqlstring;

         executesqlstr;

         selectfound_rows() into totalcount;

        

 

END