php - 将 CSV 文件直接导入 MySQL

Question

我想将 csv 文件导入 mysql.. 类似:

load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)

http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/

但 csv 中的列名与数据库表中的列名不同，我该怎么办？我想以编程方式进行..

Answer 1

but column names in csv and that in database table are different what should i do?

没问题。您可以指定将哪个 CSV 列导入到哪个数据库列。

LOAD DATA INFILE syntax

By default, when no column list is provided at the end of the LOAD DATA INFILE statement, input lines are expected to contain a field for each table column. If you want to load only some of a table's columns, specify a column list:

LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);

当我发现 INFILE 语法太复杂时，我喜欢做的是使用像 HeidiSQL 这样的图形客户端。单击正确的列顺序(它有图形预览)并复制并粘贴生成的 SQL 查询。