lundi 18 avril 2016

Insert a row in a table with AUTOINCREMENT column

I have this table

CREATE TABLE "INGREDIENTS" (
       "id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , 
       "material" VARCHAR, 
       "type" VARCHAR, 
       "company" VARCHAR
 )

and I want to add a row

INSERT INTO "INGREDIENTS" VALUES('material1','type1','company1');

and I get an error, ... has 4 columns but 3 values supplied

However, I want the row to get the id value +1 from the previous row ..

Aucun commentaire:

Enregistrer un commentaire