offset是偏移量
select id from test limit 10 offset 0;
image.png
select id from test limit 10 offset 1;
image.png
select id from test limit 10,0;
select id from test limit 10 offset 0;
查出的都是1-10条记录。
实现分页需要结合pageNum,pageSize
offset_ = (pageNum-1)*pageSize
select id from test limit pageSize,offset
select id from test limit pageSize offset offset_













网友评论