MySQL: Column count doesn’t match value count at row 1

If you are getting the following error in your MySQL Column count doesn’t match value count at row 1.

The solution is to cross check the columns in your Insert query, it could be possible that the insert query columns and and insert query params count are mismatched, example:

INSERT INTO `YourTable`
(
  `UserID`,
  `UserName` 
)
VALUES
	(
  pUserID,
  pUserName,
  pFirstName 
	);

If the above query there are 3 values being inserted into two columns. The solution is to match the count:

INSERT INTO `YourTable`
(
  `UserID`,
  `UserName` 
)
VALUES
	(
  pUserID,
  pUserName 
	);

Matching the count will fix the issue.

Related Posts: