读书人

请教怎么insert一条记录到有自增列的表

发布时间: 2012-05-16 11:12:12 作者: rapoo

请问如何insert一条记录到有自增列的表?
有这样一张表
CREATE TABLE "DB2INST1"."ABC" (
"ABC_ID"INTEGERNOT NULLGENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),
"ABC_NAME"VARCHAR(32),
"CREATED_DT"TIMESTAMP,
"UPDATED_DT"TIMESTAMP,
)

求SQL用来插入一条新数据!

[解决办法]
把自增列空出来
insert into "DB2INST1"."ABC"(ABC_NAME,CREATED_DT,UPDATED_DT) ...

读书人网 >IBM DB2

热点推荐