Unanswered: Some letters are missing in the uploaded database??
I am trying to upload a CSV file using the LOAD DATA INFILE command. The data is getting uploaded, but when I see the data, in the First column
1) Some of the rows have their first letter missing
2)Some of the rows have 2 or more than two letters missing
3) only one row has the full name without missing any thing
Can anyone please tell me as to what the reason could be??
It might help if you gave us a little more info ie
which line went in perfectly - was it the 1st line?
the full command you are using to load the data
some info on the file, assuming you're on unix run the following command to show us what's actually in your file. The head just passes the first line to the command od which shows all the funny characters that are present :
Sorry about that. I should have given you more data. This is the complete command I am using.
LOAD DATA INFILE 'C:/Users/Sashikanth/desktop/buildings.csv' INTO TABLE sashi4 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '/n' (BN, BC);
When I upload the data in the form of .txt file, with a comma between the first column and second column, the 3rd row from the bottom goes in correctly. This particular row has a building code which is not entirely numeric. It has an alphabet in the code. I do not know if that is causing some issue. I have attached the .txt file to this post.