declare @StartRow int,@EndRow int
,@PageIndex int=5,@PageSize int=10
set @StartRow=(@PageIndex-1)*@PageSize+1
set @EndRow=(@PageIndex-1)*@PageSize+@PageSize
select @StartRow,@EndRow declare @StartRow int,@EndRow int
,@PageIndex int=5,@PageSize int=10
set @StartRow=(@PageIndex-1)*@PageSize+1
set @EndRow=(@PageIndex-1)*@PageSize+@PageSize
select @StartRow,@EndRow ![【MySQL数据库】数据库索引事务1.索引2.事务[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)