Importing specific fields/columns of a CSV file with mySQL

Asked Mar 30 '23 at 20:38

Active Mar 30 '23 at 22:18

Viewed 14 times

I am wanting to import certains fields of a CSV, not all of them.

I am using: (MySQL)

load data infile 'pathToCSV' 
into table 'tablename' 
fields terminated by ',' 
lines terminated by '\n';

Is there a way to only load specific fields from the CSV? For example, field 1 of csv is field 1 of table, but field 3 of csv is field 2 of table. TIA for answers :)

edited Mar 30 '23 at 22:18

Barmar

741,623
53
500
612

asked Mar 30 '23 at 20:38

Garrett Payne

Import all cols into a temp table and then seect from that into the real table – RiggsFolly Mar 30 '23 at 20:48
Of use something like PHP to read the CSV and write to the DB – RiggsFolly Mar 30 '23 at 20:48

Importing specific fields/columns of a CSV file with mySQL

0 Answers0