INSERT문에 SELECT 가능!

INSERT 문에도 SELECT 사용가능

모든 컬럼 복사

INSERT INTO 목적지테이블
SELECT * FROM 출발지테이블

지정 컬럼 복사

INSERT INTO 목적지테이블
(컬럼명1, 컬럼명2, 컬럼명3)
SELECT 컬럼명1, 컬럼명2, 컬럼명3
FROM 출발지테이블

예시

INSERT INTO username_history (user_id, user_name) SELECT user_id, user_name FROM user

INSERT INTO username_history (user_id, user_name) SELECT user_id, user_name FROM user ORDER BY user_id

출처

: https://zetawiki.com/wiki/SQL_SELECT_%EA%B2%B0%EA%B3%BC%EB%A5%BC_INSERT_%ED%95%98%EA%B8%B0

---