MySQL Error message with LOAD DATA LOCAL INFILE

Question

My error message is:

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 'auto'' at line 5

My query is:

LOAD DATA LOCAL INFILE 'D:\file.csv'
INTO TABLE `tableName`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\'
LINES TERMINATED BY 'auto'

I'm running the query via php function mysql_query();

Michael Berkowski · Accepted Answer · 2011-11-29 14:22:18Z

2

The problem here is that the query sees an unclosed single quote after defining the escape sequence.

 ESCAPED BY '\' <-- unclosed quote!

By default, MySQL uses a backslash as the escape character. If you wish to be explicit, I believe you will need to use a double-backslash:

 ESCAPED BY '\\'

Then, remove the quotes around 'auto'.

edited Nov 29, 2011 at 14:22

answered Nov 29, 2011 at 14:13

Michael Berkowski

271k47 gold badges451 silver badges395 bronze badges

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

Comments

LostMohican · Accepted Answer · 2011-11-29 14:13:20Z

0

try putting auto out of ''

LINES TERMINATED BY auto

or use

LINES TERMINATED BY '\r\n'

answered Nov 29, 2011 at 14:13

LostMohican

3,1447 gold badges33 silver badges42 bronze badges

1 Comment

SAVAFA Over a year ago

Are you sure LINES TERMINATED BY auto does work?! It generates error.

Collectives™ on Stack Overflow

MySQL Error message with LOAD DATA LOCAL INFILE

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related