SQL
SQL_SELECT INTO
S_pot
2021. 5. 28. 16:21
SELECT * INTO buyTbl2 FROM buyTbl; --buyTbl을 buyTbl2로 복사
SELECT * FROM buyTbl2;
SELECT * FROM buyTbl;
SELECT userID, prodName INTO buyTbl3 FROM buyTbl; --지정한열만 일부복사
SELECT * FROM buyTbl3;
그러나 기본키(PK)나 외래키(FK)는 복사되지 않는다.