??????????????????????????????????????????????е?????????????У????????????????????????????????????????????MySQL??????е???????й?limit?????????
??????????????limit????????????????????????????????????С??????????о?????limit?????κ??????????????????????????????limit??????????????????????????????ó?????????
???????????????????????????????????????????????10???????
??????1??offset???С?????
????select * from user limit 10??10;
????????SQL????????У????????0.0004-0.0005???
????Select * From user Where uid >=( Select uid From user Order By uid limit 10??1 ) limit 10;
????????SQL????????У????????0.0005-0.0006????????0.0006??
????????????offset??С???????????limit??????????????????????
??????2??offset??????
????select * from user limit 10000??10;
????????SQL????????У????????0.0187????
????Select * From user Where uid >=( Select uid From user Order By uid limit 10000??1 ) limit 10;
????????SQL????????У????????0.0061????????????1/3?????????offset???????????
???????????????????ó?????????????limit?????????????????????С??????????????limit??????????????????????????????????????????????????????????