php - 上传 csv 文件以选择表中的列

Question

我有一个 CSV 文件，它有 3 列，我的表有 4 列(其中一列是一个 id 自动增量，我想自动增量)。我想将 3 列从 csv 加载到表中选定的 3 列。

尝试过的代码:

LOAD DATA LOCAL INFILE 'info.csv' INTO TABLE tbl_countryip (ipstart, ipend, countrycode) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'  ;

抛出错误:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'' at line 1

Answer 1

列列表在您的语句中的位置错误。遵循文档中的语法。

你想要这样的东西:

  LOAD DATA LOCAL INFILE 'info.csv' 
  INTO TABLE tbl_countryip 
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  (ipstart, ipend, countrycode) 

引用:http://dev.mysql.com/doc/refman/5.5/en/load-data.html