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') a..