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

count, mysql

Solution

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');

Problem

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'); ```

Original source