mysql分页 limit,limit offset

limit:

SELECT

keyword

FROM

keyword_rank

WHERE

advertiserid='59'

ORDER BY

keyword

LIMIT 2 ,1;

limit后面是从第2条开始读,读取1条信息;

SELECT

keyword

FROM

keyword_rank

WHERE

advertiserid='59'

order by keyword

LIMIT 2 OFFSET 1;

limit后面跟的是2条数据,offset后面是从第1条开始读取

 

posted @ 2018-08-07 09:12  dangerous_11  阅读(349)  评论(0)    收藏  举报