Insert table and CREATE table as differences

Insert into table1 (columns1,columns2) Select columns1,columns2 from table2;

The results of the query from Table2 are inserted into the Table1, provided that Table1 and table2 already exist;

Select Columns1 into table2 from table1 is not supported in Oracle ;

Its syntax is create. As .. Select, there are the following three ways;

1. CREATE TABLE table1 as select * from Table2 where 1=2;

Create a table structure that is identical to table2, and copy only the structure without copying the data;

2.create table table1 as select * from table2 ;

Create a table with the same table structure as the table2, and copy the structure while copying the data;

3.create table table1 (columns1,columns2) as select columns1,columns2 from table2; Create a table with the same table structure as the table2, copy the structure and copy the data, but specify the column name of the new table

Note "http://www.cnblogs.com/Neil223/p/5213895.html"

Insert table and CREATE table as differences