摘要:
--结构和数据都要SELECT * INTO kobe24 FROM T_BASE_TERM--只要结构SELECT * INTO kobe24 FROM T_BASE_TERM WHERE 1=2--将一张表数据插入到另一张表中INSERT INTO kobe24 SELECT * FROM T_BASE_TERM WHERE XQ_ID=10 阅读全文
摘要:
--提取表结构create table T_DJ_PYRRY as select * from DSIDEAL.T_DJ_PYRRY where 1=2;--提取表结构和数据create table T_DJ_PYRRY as select * from DSIDEAL.T_DJ_PYRRY 阅读全文