Column count doesn t match value count at row 1

Question

I used a SQL dump file as the last entry mentioned below:-

INSERT INTO `wp_posts` VALUES(2781, 3, '2013-01-04 17:24:19', '2013-01-05 00:24:19'.

I have been 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'

But I keep getting the ERROR, "Column count doesn't match value count at row 1." So I am confused and 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?

Answer 1

The ERROR you are receiving implies that you are providing not as much data as the table wp_posts includes the various columns and due to this, 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:

insert into wp_posts (column_name1, column_name2) values (1, 3)

Check up the table definition and see which columns you want to fill. Following which insert means you are inserting a new record. You are not modifying an existing one. Use an update for that.