i'm inserting numbers into mysql and thought varchar would accept comma seperated numbers; 1,000,000 but evidently not. Getting error 'Column count doesn't match value count at row 1' unless commas are removed. Tried most col value types.
What is the right type? Will mysql even take this?
This is very strange because I have another col with varchar on the same page that takes the comma numbers, which is set to NO (NULL)/0 default, whereas the first one is set to YES(NULL)/null default. Yet even when I set the first one to NO (NULL)/0 default I get the same error. Commas always have to be removed. Has anybody come across anything like this?
Is this a mysql bug?
