db2复制表及表数据

  • 时间:
  • 来源:互联网

今天我们来说说db2复制表create table:
create table jc_tmp as (select * from JC_VIDEO) WITH DATA;

插入数据:
insert into table_name_new (select * from table_name_old);

DB2复制表结构:
create table table_name_new as (select * from table_name_old) definition only;

本文链接http://element-ui.cn/news/show-2253.html