So I read the other posts but this question is unique. So this SQL dump file has this as the last entry.
INSERT INTO `wp_posts` VALUES(2781, 3, '2013-01-04 17:24:19', '2013-01-05 00:24:19'.
I’m trying to insert this value to the table…
INSERT INTO `wp_posts` VALUES(5, 5, '2005-04-11 09:54:35', '2005-04-11 17:54:35'
it gives me the error, “Column count doesn’t match value count at row 1.” So I’m lost on the concept of how the column and row apply here.
Doesn’t 2781,3
mean row 2781 and column 3? And doesn’t 5,5
mean row 5 and column 5?
The error means that you are providing not as much data as the table
wp_posts
does contain columns. And now the DB engine does not know in which columns to put your data.To overcome this you must provide the names of the columns you want to fill. Example:
Look up the table definition and see which columns you want to fill.
And
insert
means you are inserting a new record. You are not modifying an existing one. Useupdate
for that.You should also look at new triggers.
MySQL doesn’t show the table name in the error, so you’re really left in a lurch. Here’s a working example:
MySQL will also report “Column count doesn’t match value count at row 1” if you try to insert multiple rows without delimiting the row sets in the VALUES section with parentheses, like so:
You can resolve the error by providing the column names you are affecting.
please note that the semi colon should be added only after the statement providing values
In my case i just passed the wrong name table, so mysql couldn’t find the right columns names.