댓글 페이징쿼리

꼭 sql 공부할 것

• 인덱스 생성

CREATE INDEX idx_reply ON tbl_reply(bno desc, rno asc);

• 817853번 포스트의 댓글들 뽑기

    
SELECT 
				@RN := @RN + 1 AS RN, TBL_REPLY.* 
                FROM TBL_REPLY AS TBL_REPLY USE INDEX (idx_reply)
                CROSS JOIN (SELECT @RN := 0) AS R
                WHERE TBL_REPLY.BNO = 816853;	
                

• 817853번 포스트 댓글중 2번째 페이지 댓글들만 뽑기

SELECT * 

FROM
 (
		SELECT 
				@RN := @RN + 1 AS RN, TBL_REPLY.* 
                FROM TBL_REPLY AS TBL_REPLY USE INDEX (idx_reply)
                CROSS JOIN (SELECT @RN := 0) AS R
                WHERE TBL_REPLY.BNO = 816853
) AS R
WHERE RN > (1-1) * 10 
LIMIT 10;