mysql 分页 pageindex_根据当前页号（pageIndex）和页大小（pageSize）获取分页数据

一、用存储过程

IF EXISTS(SELECT * FROM sys.objects WHERE NAME='pro_paging')

DROP PROC pro_paging

go

CREATE PROC pro_paging

(

@orderColumn varchar(20),

@tableName VARCHAR(20),

@pageSize INT,

@pageNo INT,

@strWhere varchar(20)

)

AS

DECLARE @sqlString nvarchar(500)

SET @sqlString=

'WITH newClientInfo AS

(

SELECT row_number() OVER (ORDER BY '+@orderColumn+') AS newIndex,* FROM '+@tableName +' where '+ @strWhere+'

)

SELECT * FROM newClientInfo WHERE newIndex between '+str((@pageNo-1)*@pageSize+1)+' and '+str(@pageSize*@pageNo)

EXEC sp_executesql @sqlString

EXEC pro_paging 'employID','employInfo',5,2,'sex&