CODEWITHSUNDEEP
mysqlcsv
smv
smv

Reputation: 19

Unable to load from csv to mysql table?

 LOAD DATA LOCAL INFILE 'hr.csv' INTO TABLE hr_analytics  FIELDS TERMINATED BY '`' IGNORE 1 LINES(NO,SATISFACTION_LEVEL,LAST_EVALUATION,NUMBER_PROJECT,AVERAGE_MONTLY_HOURS,TIME_SPEND_COMPANY,WORK_ACCIDENT,LEFT,PROMOTION_LAST_5YEARS,SALES,SALARY)

when i run above query i get:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT,PROMOTION_LAST_5YEARS,SALES,SALARY)' at line 1

how to solve this?

Upvotes: 0

Views: 51

Answers (2)

Idriss Benbassou
Idriss Benbassou

Reputation: 1596

The problem seems to be that LEFT is a MySQL key word. Try this:

LOAD DATA LOCAL INFILE 'hr.csv' INTO TABLE hr_analytics  FIELDS TERMINATED BY '`' IGNORE 1 LINES(`NO`,`SATISFACTION_LEVEL`,`LAST_EVALUATION`,`NUMBER_PROJECT`,`AVERAGE_MONTLY_HOURS`,`TIME_SPEND_COMPANY`,`WORK_ACCIDENT`,`LEFT`,`PROMOTION_LAST_5YEARS`,`SALES`,`SALARY`)

Upvotes: 1

Szymon Roziewski
Szymon Roziewski

Reputation: 1129

You have a problem because you use a reserved SQL word 'LEFT'.

If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it.

The identifier quote character is the backtick "`".

Upvotes: 0

Related Questions