insert into select

생성하며 넣기

SELECT select_list

 INTO new_table_name

 FROM table_list

 WHERE search_conditions

데이터만 넣기

insert into table_name

SELECT * FROM table_list

http://blog.naver.com/babo_box/10040923316