MySQL Paging limit,limit offset

Limit

SELECT

Keyword

from

Keyword_rank

WHERE

Advertiserid=' a '

ORDER by

Keyword

LIMIT 2,1;

The limit is followed by the 2nd reading, reading 1 messages;

SELECT

Keyword

from

Keyword_rank

WHERE

Advertiserid=' a '

< Span class= "hljs-string" > order by Keyword

< Span class= "hljs-string" >LIMIT Span class= "Hljs-number" >2 OFFSET 1;

The limit is followed by 2 data, and offset is followed by reading from 1th

MySQL Paging limit,limit offset