SQL - Column count doesn't match value count at row 1

Question

I am trying to put this into the database. All rows are correct. Each row is also String/Text, except for "Id" which is an auto-incrementing Int value.

I am getting an unexpected error, however, saying Column count doesn't match value count at row 1. What is wrong with the query?

INSERT INTO  `world2_main`.`Messages` (
`Id` ,
`ToId` ,
`FromId` ,
`Subject` ,
`Message` ,
`Read` ,
`Original Sender` ,
`Date`
)
VALUES (
NULL,  '3611',  '156',  'You are so...',  'Cool.',  '0',  '3611'  '1338590308');

score 10 · Accepted Answer · edited Jan 28 '22 at 13:28

10

well Id is an autoincrementing int value, and you put a null in it.

Just do

INSERT INTO  `world2_main`.`Messages` (
`ToId` ,
`FromId` ,
`Subject` ,
`Message` ,
`Read` ,
`Original Sender` ,
`Date`
)
VALUES (  '3611',  '156',  'You are so...',  'Cool.',  '0',  '3611'  '1338590308');

EDIT :in fact was just a missing comma after 3611. But avoiding inserting id is still good.

INSERT INTO  `world2_main`.`Messages` (
    `ToId` ,
    `FromId` ,
    `Subject` ,
    `Message` ,
    `Read` ,
    `Original Sender` ,
    `Date`
    )
    VALUES (  '3611',  '156',  'You are so...',  'Cool.',  '0',  '3611',  '1338590308');

edited Jan 28 '22 at 13:28

questionto42

7,175
4
57
90

answered Jun 01 '12 at 22:47

Raphaël Althaus

59,727
6
96
122

Still errors with "Column count doesn't match value count at row 1" – Anonymous Jun 01 '12 at 22:48
Thanks for seeing that. Small mistake that took me days to even come close to, lol. I just saw the error a few minutes ago. Appreciate it mate. – Anonymous Jun 01 '12 at 22:54

score 6 · Answer 2 · edited Jun 29 '15 at 14:20

6

I have also discovered that if you have a trigger on the table you want to insert into and that trigger have another insert statement with un-matching columns and values, it will throw that error "Column count doesn't match value count at row ".

edited Jun 29 '15 at 14:20

Brian Tompsett - 汤莱恩

5,753
72
57
129

answered Jun 29 '15 at 14:17

Ngoni Mtanhaurwa

61
1
2

score 2 · Answer 3 · answered Apr 19 '19 at 21:15

2

You may have defined different number of parameters and are probably passing a different number of parameters.

You may have:

INSERT INTO `buyers`(`key1`,  `key2` )
VALUES (value1,value2,value3 );

or more number of arguments in INSERT INTO than in the VALUES

answered Apr 19 '19 at 21:15

Vedha Peri

1,386
2
12
11

this was my issue, the number of parameters **must** match – João Pimentel Ferreira May 05 '19 at 23:00

score 2 · Answer 4 · answered Apr 16 '20 at 20:54

Keep in mind 3 things:

Number of parameters must match
auto increment should be taken care of
(This was my issue) When inserting multiple attributes

don't do this--

insert into agent(eid, ename, email, phone, score) values(
    (2, 'b', 'b', 5, 3),
    (1, 'a', 'a', 5, 3)
   );

You have to do this instead

insert into agent(eid, ename, email, phone, score) values
    -> (1, 'a', 'a', 5, 3),
    -> (2, 'b', 'b', 5, 3);

Thanks

SQL - Column count doesn't match value count at row 1

4 Answers4