How to insert data into database with a auto_increment key in go

Question

I have a SQL database with a table named blogpost, it has a column id set to auto_increment now I have to insert a value into the database, I used the following code:

 _, err := db.Exec("Insert  into blogpost (id, title, description, author) values(?,?,?)", newBlog.Title, newBlog.Description, newBlog.Author)

but I get a following error:

Column count doesn't match value count at row 1

DeveloperLV · Accepted Answer · 2022-06-24 10:21:56Z

4

Column count doesn't match value count at row 1 is displayed because you've defined 3 parameters and not 4.

You defined id, title, description and author which is a total of 4 columns. Whereas where you provide your values, you only have a total of 3 values(?,?,?).

If you have the id already set as auto_icnrement, you don't need to do anything in your insert method, just take it out like so:

 _, err := db.Exec("Insert  into blogpost (title, description, author) values(?,?,?)", newBlog.Title, newBlog.Description, newBlog.Author)

answered Jun 24, 2022 at 10:21

DeveloperLV

1,8013 gold badges20 silver badges49 bronze badges

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

Comments

gaspx · Accepted Answer · 2022-06-24 10:21:39Z

1

try to remove id from fields list

answered Jun 24, 2022 at 10:21

gaspx

464 bronze badges

Collectives™ on Stack Overflow

How to insert data into database with a auto_increment key in go

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related