sql小常识

  复制表(只复制结构,源表名:a 新表名:b)

  SQL: select * into b from a where 1<>1

  拷贝表(拷贝数据,源表名:a 目标表名:b)

  SQL: insert into b(a, b, c) select d,e,f from b;

原文地址:https://www.cnblogs.com/xinlang/p/1451944.html