가자공부하러!

1. 페이징1234567SELECT *FROM ( SELECT @ROWNUM := @ROWNUM + 1 as rnum, SEQ, id, COMMENT, AMOUNT, RDATE FROM RHY_MEM_POINT, (SELECT @ROWNUM :=0) A ORDER BY RDATE DESC ) RESULTLIMIT 10, 10Colored by Color Scriptercs > 결과 2. 날짜1234567891011-- 날짜 포맷 설정(yyyy-mm-dd)DATE_FORMAT(RDATE,'%Y-%m-%d') -- 날짜 더하기 빼기DATE_ADD(NOW() , INTERVAL 12 DAY),'%Y-%m-%d'DATE_ADD(NOW() , INTERVAL 12 MONTH),'%Y-%m-%d'DATE_ADD(N..