记录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;