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
Post a Comment