In used query to create derby database table consist of primary column auto increment.
CREATE TABLE "table" (
"
+ " "id" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
"
+ " "path" VARCHAR(2000) DEFAULT NULL,
"
+ " "downloaded" BOOLEAN DEFAULT false NOT NULL,
"
+ " "retried_times" SMALLINT DEFAULT 0 NOT NULL,
"
+ " "name" VARCHAR(40),
"
+ " "downloaded_date" TIMESTAMP DEFAULT NULL,
"
+ " PRIMARY KEY ("id")
"
When i insert a row through spring jdbc
it increment by 100. Is there any error in query?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…