MySQL Forums
Forum List  »  Install & Repo

Re: ERROR: 1136 Column count doesn't match value count at row 1
Posted by: David Myers
Date: February 11, 2009 01:46AM

Hello All,

I was getting this error message also.

I don't know if it has now been solved but....

I realised that it was an issue of copying data from one table to another (this is how I "normalise" my tables, as my raw data is in one BIG file).

I found that I had made 2 errors.
firstl
I was trying to select all the columns into a table that didn't have the required number of column (ie column count didn't match) to receive them all! this came down to the structure of my original file containing a mixture of tabs and '|' as column seperators - the solution was to use AWK (in linux) to change all of the tab spaces to '|' and then re work the <load data infile> command to take into account the new extra columns!

second.
i had this when i was trying to import a value from one table to another, and (partly due again to the above TAB and '|' issue) I found that one of the target column sizes lengths didn't match the source column size.

Hope this helps.

David

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.