페이지 나누기 오라클 -> MySQL & MariaDB

오라클 일때

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 & MariaDB 일때

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;

Oracle                                 MySQL & MariaDB

SYSDATE                                     NOW()

TO_CHAR(regdate, 'YYYY-MM-DD')            DATE_FORMAT(regdate, '%Y-%m-%d')