1.informix中自动增长列:
create temp table aaa_tmp
(id serial,
idno char(18)
)
;
insert into aaa_tmp
select 0,dddd
from dddd_tmp
;
2.Teradata中自动增长列:
CREATE SET TABLE test ,NO FALLBACK ,
NO BEFORE JOURNAL,NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
1.informix中自动增长列:
create temp table aaa_tmp
(id serial,
idno char(18)
)
;
insert into aaa_tmp
select 0,dddd
from dddd_tmp
;
2.Teradata中自动增长列:
CREATE SET TABLE test ,NO FALLBACK ,
NO BEFORE JOURNAL,