Search code examples
sqlmysqlcsvimportload-data-infile

Importing CSV to MySQL with Load Data Infile

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.

Solution

  • 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