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