请问如何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) ...