如何导入CSV文件

有一个表ip_to_country,包含以下定段
ip_from,ip_to,registry,assigned,ctry,cntry,country
有一个CSV文件，有以下格式的数据
"16777216","17367039","AU","AUS","AUSTRALIA"
"17367040","17432575","MY","MYS","MALAYSIA"
"17432576","17498111","AU","AUS","AUSTRALIA"
"17498112","17563647","KR","KOR","REPUBLIC OF KOREA"
"17563648","17825791","CN","CHN","CHINA"
"17825792","18087935","KR","KOR","REPUBLIC OF KOREA"
"18087936","18153471","AU","AUS","AUSTRALIA"
"18153472","18219007","JP","JPN","JAPAN"
"18219008","18350079","IN","IND","INDIA"
"18350080","18874367","CN","CHN","CHINA"
"18874368","18939903","AU","AUS","AUSTRALIA"我现在需要将CSV文件导入到表的ip_from,ip_to,ctry,cntry,country

解决方案 »

  1.   

    直接用SQL语句 LOAD DATA INFILE
      

  2.   

    load data INFILE 'c:\\test\\有一个CSV文件.csv'
    Into Table ip_to_country
    FIELDSTERMINATED BY ','
    ENCLOSED BY '"'
    (ip_from,ip_to,ctry,cntry,country);
      

  3.   

    使用： 
    mysql>load data infile 'E:\\demo\\csvdata.csv' into table tt FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (id_from, id_to, ctry, cntry, country);Query OK, 11 rows affected (0.02 sec)
    Records: 11  Deleted: 0  Skipped: 0  Warnings: 0注意换行符的控制。
      

  4.   


    ACMain很厉害,如果他是我数据库老师就好了.