Importing CSV to MySQL with Load Data Infile

Question

I'm trying to load a CSV file into MySQL, and I keep getting syntax errors:

load data infile 'c:/worldminwage.csv' fields terminated by ',' enclosed
by '"' lines terminated by '\n' (YearlyWage, PercentGDP, Date
effective);

Can anyone help me get this working? Thanks.

UdayKiran Pulipati · Accepted Answer · 2014-03-26 06:24:29Z

5

Valid syntax is LOAD DATA INFILE 'c:/worldminwage.csv' INTO TABLE tablename.

You forgot to mention which table the data should go in. See LOAD DATA INFILE Syntax

6,6877 gold badges70 silver badges95 bronze badges

answered Dec 19, 2010 at 23:34

Oswald

31.8k3 gold badges45 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chirag · Accepted Answer · 2014-04-11 09:21:26Z

1

I think This would be more batter

LOAD DATA INFILE 'c:/worldminwage.csv' fields terminated by ',';

Because you will get rid of error like columns numbers are not matching in the .csv file and mysql table

answered Apr 11, 2014 at 9:21

Chirag

5251 gold badge6 silver badges19 bronze badges