Mysql分页存储过程

关注

原创最新推荐文章于 2026-02-09 08:56:00 发布 640 阅读 AI 写同款· GEO 优化 ›

mysql 分页存储过程 网上关于mysql分页存储过程的资料很多，但内容大同小异。作为初学者，引用mysql存储过程如下： DELIMITER $$USE `database1`$$ -- 数据库名称DROP PROCEDURE IF EXISTS `Query_Pagination`$$ -- 分页存储过程名称，存在则删除CREATE DEFINER=`root`@`%` PROCEDURE `Query_Pag 阅读详情

记下来以后要用直接过来copy了

http://blog.youkuaiyun.com/xugangjava

CREATE DEFINER=`root`@`localhost` PROCEDURE `pageSplit`(
fromWhere varchar(50),
selectColum varchar(500),
orderBy varchar(100),
conditions varchar(500),
curPage int,
pageSize int,
OUT totalCount int)
BEGIN
DECLARE countSQL varchar(1200);
DECLARE selectSQL varchar(1200);
IF conditions!='' THEN
SET conditions=concat(' where ',conditions);
END IF;

SET countSQL=concat('select count(1) into @recordcount from ',fromWhere,conditions);
SET @sqlCount:=countSQL;
PREPARE stmt FROM @sqlCount;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET totalCount:=@recordcount;
IF curPage<1 THEN
SET curPage=1;
END IF;
IF pageSize<1 THEN
SET pageSize=1;
END IF;
IF orderBy!='' THEN
SET orderBy=concat(' order by ',orderBy);
END IF;

SET selectSQL=concat('select '
,selectColum,
' from ',fromWhere
,conditions,' '
,orderBy,' limit '
,(curPage-1)*pageSize
,',',pageSize, ' ');
SET @sqlSelect:=selectSQL;
PREPARE stmtselect FROM @sqlSelect;
EXECUTE stmtselect;
DEALLOCATE PREPARE stmtselect;
END