①select * from tableA limit a,b; -- 跳过前a条数据,读取后b条数据;
②select * from tableA limit a; -- 读取前a条数据;
③select * from tableA limit a offset b; -- 跳过前b条数据,读取后a 条数据;
①select * from tableA limit a,b; -- 跳过前a条数据,读取后b条数据;
②select * from tableA limit a; -- 读取前a条数据;
③select * from tableA limit a offset b; -- 跳过前b条数据,读取后a 条数据;