/*테이블 구조 복사*/ CREATE TABLE talbe_name_copy LIKE talbe_name; /*테이블 데이터 전체 복사*/ INSERT INTO talbe_name_copy SELECT * FROM talbe_name; /*테이블 데이터 조건 복사*/ INSERT INTO talbe_name_copy SELECT * FROM talbe_name where (talbe_name 조건); /*필드별 매칭 조건 복사*/ INSERT INTO talbe_name_copy (idx, name) SELECT idx, name FROM talbe_name;