同时建立新表: SQL SERVER 如下 SELECT * INTO TABLE2 FROM TABLE1; ORACLE如下: CREATE TABLE TABLE2 AS SELECT * FROM TABLE1; 表已存在: INSERT INTO TABLE2 SELECT * FORM TABLE1;