今天我们来说说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;
今天我们来说说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;