记录Sql语句

• 把表1的数据复制到表2

  INSERT INTO 表2(CRT_Time,CatalogID,TypeID,ArticleTitle,Content) SELECT CRT_Time,CatalogID,TypeID,ArticleTitle,Content FROM 表1;

• 复制表结构

   create table newTable as select * from oldTable where 1=0;

• 复制表结构和数据

    create table newTable as select * from odlTable;