MySQL insert value error

Question

1.00/5 (1 vote)

See more:

MySQL server returns an an Error an Error to the visual basic IDE :

MySqlExeception was unhandled : Column count does't match value count at row 1.

This error still occured when a Auto incrementing , nullable column was ommited during the query.

Posted 16-Apr-13 1:45am

compuknow

Add a Solution

Comments

Member 9762654 16-Apr-13 7:49am

can you send the query?

Prasad Khandekar 16-Apr-13 7:49am

Hello,

The error is self explanatory you are specifying more values than the number of columns. Check the Values part of your SQL and ensure that number of values specified are exactly same as the number of coulmns specified. Please post the code snippet.

The general format of your INSERT query will be

INSERT INTO TABLE_NAME(COL1, COL2, ..., COLN) VALUES(VAL1, VAL2, ..., VALN)

OR If you are using bind parameters

INSERT INTO TABLE_NAME(COL1, COL2, ...COLN) VALUES(?, ?, ...)

So in first case you will have to check the actual values specified in the SQL String and in second case you will have to check number of ?, number of columns and the actual parameters supplied.

Regards,

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-04-16T01:53:00

The chances are that your query was of the form:

SQL

INSERT INTO myTable VALUES("Joe", "Bigman" "Smith")

which tries to allocate values on the basis of column numbers: if your auto number field is early in the sequence, one of the given values will be assigned to it - and you will get an error.

Instead of doing that, always name the fields whose values you are supplying:

SQL

INSERT INTO myTable (FirstName, NickNAme, FamilyName) VALUES ("Joe", "Bigman", "Smith")

That way, the database knows exactly which column you are trying to insert a value to, and can use defaults or it's own numbers for the remainder. Plus it's a good idea to list the columns anyway, as it prevents data corruption if the table definition is changed at a later date!