在mySQL中不显示年份值(Not showing Year values in mySQL)

 我试图从下面的命令行导入csv文件中的数据，保存在E驱动器中，文件名为data.csv： 
 
LOAD DATA LOCAL INFILE 'E:\data.csv' 
into table prize_won fields 
terminated by ',' lines 
terminated by '\n';
 
 数据文件分别具有年份，主题，赢家，国家和类别。 现在，当我尝试用上面的命令导入它时，有些年份没有在表格中显示，有些是可见的，但其余条目看起来很好。 
 
 你能否建议一个可能的解决方案？ 
 
 我的data.csv文件内容看起来像 
 
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

I am trying to import data from csv file with below command line for data which is kept in E drive and file name is data.csv:
 
LOAD DATA LOCAL INFILE 'E:\data.csv' 
into table prize_won fields 
terminated by ',' lines 
terminated by '\n';
 
The data file has headers Year,subject,winner,country and category respectively. Now when i try to import it with above command, some year aren't showing in tables and some are visible however rest of entries seems fine.
 
Can you please suggest a possible solution?
 
My data.csv file contents look 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

原文：https://stackoverflow.com/questions/43412178