有这样一张表
CREATE TABLE "DB2INST1"."ABC" (
"ABC_ID" INTEGER NOT NULL GENERATED 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) ...
insert into "DB2INST1"."ABC"(ABC_NAME,CREATED_DT,UPDATED_DT)
values ('jimmy', '2011-01-01 00:00:00', '2011-01-01 00:00:00')