Mysql limit 사용법

//아래 예는 5개 가져오기  

SELECT * FROM [TABLE NAME] LIMIT 5; 

SELECT * FROM [TABLE NAME] LIMIT 5;

 

// LIMIT 시작점, 갯수 (아래 예의 경우 5번째부터 10개 추출. 첫번째 파라미터는 0 부터 시작함!)  

SELECT * FROM [TABLE NAME] LIMIT 4, 10;