csv - Not showing Year values in mySQL -


i trying import data csv file below command line data kept in e drive , file name data.csv:

load data local infile 'e:\data.csv'  table prize_won fields  terminated ',' lines  terminated '\n'; 

the data file has headers year,subject,winner,country , category respectively. when try import above command, year aren't showing in tables , visible rest of entries seems fine.

can please suggest possible solution?

my data.csv file contents like

1970    physics      hannes alfven    sweden    scientist 1970    physics      louis neel       france    scientist 1970    chemistry    luis federico    france    scientist 1970    physiology   ulf von euler    sweden    scientist 

open csv in text editor can see if formatting (the enclosers, delimiters) consistent. should able see double quotes on fields. double quotes enclosed '"' line that's missing in statement default parsing csv in mysql.


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -