MYsql insert statement error

Question

I'm getting a mysql error when running an insert statement. The error is:

#1136 - Column count doesn't match value count at row 1. The insert has 5 values, BUT the comment id is set to AUTO INC

The insert statement looks like this:

insert INTO comments (post_id, comment_name, comment_email, comment_text, status) VALUES ('78', 'm man', '[email protected]', 'testh' 'unapprove')

The table looks like this

1) comment_id       int(10)     AUTO_INCREMENT  
2) post_id          int(10)                 
3) comment_name     varchar(100)
4) comment_email    varchar(100)  
5) comment_text     (text)  
6) status           (text)

Can anyone help? many thanks for your efforts

You're missing a comma in the values clause.

thebjorn
– thebjorn

2014-08-31 09:53:19 +00:00
Commented Aug 31, 2014 at 9:53 — thebjorn
– thebjorn, Commented Aug 31, 2014 at 9:53

sergio · Accepted Answer · 2014-08-31 09:55:10Z

2

You have make a mistake. You forget to set the comma between all values. Change you query from:

insert INTO comments (post_id, comment_name, comment_email, comment_text, status) VALUES ('78', 'm man', '[email protected]', 'testh' 'unapprove')

to

insert INTO comments (post_id, comment_name, comment_email, comment_text, status) VALUES ('78', 'm man', '[email protected]', 'testh', 'unapprove')

answered Aug 31, 2014 at 9:55

sergio

5,2607 gold badges27 silver badges47 bronze badges

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

Comments

Md. Salahuddin · Accepted Answer · 2014-08-31 09:56:33Z

1

You should add comma after 'testh' since it it a value for comment_text field.

insert INTO comments (post_id, comment_name, comment_email, comment_text, status) VALUES 
                     ('78', 'm man', '[email protected]', 'testh', 'unapprove')

answered Aug 31, 2014 at 9:56

Md. Salahuddin

1,07215 silver badges23 bronze badges

Comments

subham soni · Accepted Answer · 2014-08-31 09:57:18Z

0

You have to modify your query to this

insert INTO comments VALUES (NULL, '78', 'm man', '[email protected]', 'testh',  'unapprove')

answered Aug 31, 2014 at 9:57

subham soni

2721 gold badge6 silver badges17 bronze badges

Collectives™ on Stack Overflow

MYsql insert statement error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related