페이징을 하기위해 복사 데이터를 만들때

오라클 ver. 

insert into mp_board(bno, title, content, writer) select mp_board_seq.nextval, title, content, writer from mp_board; commit;

 

mysql ver.

insert into mp_board(bno, title, content, writer)
select CONCAT(max(bno)+1), title, content, writer from mp_board;
commit;