[MySQL] Pagination LIMIT

LIMIT A

A번째 까지만 출력

SELECT * FROM copang_main.member
ORDER BY sign_up_day DESC
LIMIT 10;

 

LIMIT A,B

A번째에서 B개까지 출력

SELECT * FROM copang_main.member
ORDER BY sign_up_day DESC
LIMIT 8,2; -- 8 : 9번째를 의미 / 2 : 8에서 두 개

 

Pagenation

1페이지 : SELECT * FROM db.search_result ~ ORDER BY registration_date DESC LIMIT 0, 10

2페이지 : SELECT * FROM db.search_result ~ ORDER BY registration_date DESC LIMIT 10, 10

3페이지 : SELECT * FROM db.search_result ~ ORDER BY registration_date DESC LIMIT 20, 10

4페이지 : SELECT * FROM db.search_result ~ ORDER BY registration_date DESC LIMIT 30, 10

...