MySQL 페이지 나누기

오라클 일때

SELECT no,subject,name,dbday,hit,num 
FROM (SELECT no,subject,name,TO_CHAR(regdate, 'YYYY-MM-DD') as dbday,hit,rownum as num 
FROM (SELECT no,subject,name,regdate,hit 
FROM board ORDER BY no DESC)) 
WHERE num BETWEEN 1 AND 10;

 

MySQL 일때

SELECT no,subject,name,dbday,hit,num 
FROM(SELECT @RNUM := @RNUM + 1 AS num, a.* 
FROM (SELECT no,subject,name,DATE_FORMAT(regdate, '%Y-%m-%d') as dbday,hit FROM board) a, ( SELECT @RNUM := 0 ) b)c 
WHERE c.num BETWEEN 1 AND 10 
ORDER BY no DESC;