记录一些常用的sql 语句

1336 0

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

发表回复