mysql 分頁 limit offset,limit
pageNo 1; pageSize2
offset =? (pageNo - 1) * pageSize; =0;
limit = pageSize = 2;
eg : limit 0,2? ->結(jié)果從0開始2條數(shù)據(jù),0是第一條數(shù)據(jù).
limit 2,2 ->結(jié)果從索引2開始2條數(shù)據(jù),2是第三條.
orcal分頁
pageNo 1; pageSize2
BEGINRN? (currentPage*pageSize)-pageSize; ->0
ENDRN ->currentPage*pageSize ->2
pageNo 2;pageSize2
BEGINRN 2
ENDRN 4
