表复制语句

1.INSERT INTO SELECT语句

     语句形式为：Insert into Table2(field1,field2,...) select value1,value2,... from Table1

     要求目标表Table2必须存在
      如：INSERT INTO teachercopy SELECT * FROM teacher

2  CREATE TABLE teacherB AS SELECT * FROM teacher;   //mysql测试ok  

    要求目标表tableB 不存在

3  SELECT INTO FROM语句  
    语句形式为：SELECT vale1, value2 into Table2 from Table1
    要求目标表tableB 不存在
    如：SELECT * INTO teacherB FROM teacher;   //mysql测试不通过，   oracle没有测试