Adding row to Table - Primary Key/Auto Increment Error(System.Data.SQLite)

Question

I'm trying to insert a new row into a database which has four fields, the first is a primary key set as auto incrementing (integer) and the other three are strings.

I insert a new with the following statement:

INSERT INTO Manufacturer VALUES ('Test1','Test2','01332232321')

But I am given the following exception:

"SQLite error\r\ntable Manufacturer has 4 columns but 3 values were supplied"

I assumed that the primary key field can be omitted as the database would automatically assign and increment the value for me.

How would I go about fixing this? Is this a simple syntatical error or do I need to rethink my approach completely?

HABJAN · Accepted Answer · 2011-03-30 22:16:44Z

1

You have to specify columns:

INSERT INTO Manufacturer (col2, col3, col4) VALUES ('Test1','Test2','01332232321')

or pass the NULL value for primary key column.

edited Mar 30, 2011 at 22:16

answered Mar 30, 2011 at 22:10

HABJAN

9,2733 gold badges38 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jamie Keeling Over a year ago

Thanks, I never realised you had to specify the columns. I was working from sqlcommands.net/sql+insert and apparently missed the obvious part: "You are allowed to omit the list of column names in the SQL INSERT INTO clause, if you enter values for each of the table columns."

MikeM · Accepted Answer · 2011-03-30 22:14:06Z

0

I think you're looking for how to AUTOINCREMENT in sqllite

also How do I create an AUTOINCREMENT field

answered Mar 30, 2011 at 22:14

MikeM

27.5k4 gold badges67 silver badges80 bronze badges

Collectives™ on Stack Overflow

Adding row to Table - Primary Key/Auto Increment Error(System.Data.SQLite)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related