MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: INSERT INTO table with "Column count doesn't match value count at row 1" error?
Posted by: Barry Galbraith
Date: May 15, 2025 04:52PM

Your list of values
Quote

...
'Daily',
1,234,
2.345,
...
has a value that includes a , (1,234) which is being taken as a separator for a value.
Your list of 9 fields is being offered 10 values.
You need to insert 1234 without the comma.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
INSERT INTO table with "Column count doesn't match value count at row 1" error?
Xavier Vasquez
May 13, 2025 11:17AM
Re: INSERT INTO table with "Column count doesn't match value count at row 1" error?
Barry Galbraith
May 15, 2025 04:52PM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.