[SQL] table 데이터 복사하기

-- 소속그룹이 'HELI'인 data들을 copy후
-- GROUP_CODE값을 'DARK'로 변경후 insert
INSERT INTO m_cyphers (
    NAME,
    AGE,
    POSITION,
    GROUP_CODE
)
SELECT
    NAME,
    AGE,
    POSITION,
    'DARK' AS GROUP_CODE,
FROM m_cyphers
WHERE GROUP_CODE = 'HELI';