How to Customize Column Mappings During CSV Import into MySQL?

Importing CSV Files into MySQL with Custom Column Mappings

When importing CSV files into MySQL, there may be instances when the column names in the CSV file differ from those in the destination table. To address this, you can specify the mapping between CSV columns and database columns programmatically using the LOAD DATA INFILE statement.

The LOAD DATA INFILE syntax allows you to specify a column list, which defines the order in which the CSV columns should be imported into the database columns. For example:

LOAD DATA INFILE 'uniq.csv' INTO TABLE tblUniq
(uniqName, uniqCity, uniqComments)

In this example, the first column in the CSV file will be imported into the uniqName column in the database table, the second column into uniqCity, and so on.

If you only need to import a subset of the database table's columns, you can specify the column list accordingly:

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

For complex mappings or previewing purposes, consider using graphical clients like HeidiSQL, which allow you to visually configure the column order and generate the corresponding SQL query.

The above is the detailed content of How to Customize Column Mappings During CSV Import into MySQL?. For more information, please follow other related articles on the PHP Chinese website!