Mysql 페이징쿼리

SELECT * FROM
(SELECT @rownum := @rownum +1 as rn, bno, title, writer, regdate, updatedate
from tbl_board, (select @rownumm :=0) as rowcolumn order by bno desc ) as rownum_table
where rn >10 and rn <= 20;

재귀 복사

insert into tbl_board(bno, title, content, writer)
(select null, title, content, writer from tbl_board);

	SELECT *
	
		 FROM 
		 
		(
			
			SELECT @ROWNUM := @ROWNUM + 1 AS RN, BNO, TITLE,CONTENT, WRITER, REGDATE, UPDATEDATE 
		
		FROM
			
			 TBL_BOARD, (SELECT @ROWNUM := 0) AS ROWCOLUMN ORDER BY BNO DESC) AS ROWNUM_TABLE 
		
		
        
       WHERE ( TITLE LIKE '%TEST%' or content LIKE '%TEST%' ) AND RN >10 AND RN <= 20;