limit:一般用法为limit X,Y意思为跳过X条数据读取Y条数据(包括X)
用法:select * from student limit 4,5;
offset:一般用法为limit x offset y,表示从y后面开始读取x条数据(不包括y)
用法:select * from student limit 2 offset 6;
用法:select * from student limit 4,5;
用法:select * from student limit 2 offset 6;