表复制

INSERT INTO ... SELECT ... FROM ...

INSERT INTO des(col1, col2...) 
     SELECT colA, colB, ... 
       FROM src

需要des表存在

 

SELECT ... INTO ... FROM ...

SELECT colA, colB...
  INTO des
  FROM src

des表不能存在，执行完成之后生成des表

表结构可以按照如下设定

SELECT colA AA, colB BB...
  INTO des
  FROM src