MySQL string returning error

Question

 "LOAD DATA LOCAL INFILE ".$file_location." INTO TABLE p4p.users_csv_import
 FIELDS TERMINATED BY ',' 
 LINES TERMINATED BY '\\n' STARTING BY ''
 IGNORE 1 LINES";

Not sure what is incorrect, but it is with my single/double quotes.

Error Number: 1064

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 'assets/temp/p4p57.csv INTO TABLE p4p.users_csv_import FIELDS TERMINATED ' at line 1

LOAD DATA LOCAL INFILE assets/temp/p4p57.csv INTO TABLE p4p.users_csv_import FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STARTING BY '' IGNORE 1 LINES

Filename: /Applications/MAMP/htdocs/models/user_import_model.php

Line Number: 28

What is the exact error message? What is the value of $file_location? Can you should us what the string looks like with the variable interpolated? — John Conde
– John Conde, Commented Jan 8, 2014 at 15:29
'' looks like an empty string, are you sure that's what you want? — Zarathuztra
– Zarathuztra, Commented Jan 8, 2014 at 15:30
The actual error message and an echo of the actual statement submitted would both be useful. — Strawberry
– Strawberry, Commented Jan 8, 2014 at 15:31

Everett Green · Accepted Answer · 2014-01-08 15:54:18Z

2

Wrap $file_location in single quotes.

Edit - specifically:

"LOAD DATA LOCAL INFILE '".$file_location."' INTO TABLE business.table
 FIELDS TERMINATED BY ',' 
 LINES TERMINATED BY '\\n' STARTING BY ''
 IGNORE 1 LINES";

edited Jan 8, 2014 at 15:54

answered Jan 8, 2014 at 15:32

Everett Green

6323 silver badges8 bronze badges

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

Comments

Giacomo1968 · Accepted Answer · 2014-01-08 15:32:12Z

0

While you are not providing an error, my gut tells me the issue is with the \n which should probably be a \\n. So try this instead.

"LOAD DATA LOCAL INFILE ".$file_location." INTO TABLE business.table
 FIELDS TERMINATED BY ',' 
 LINES TERMINATED BY '\\n' STARTING BY ''
 IGNORE 1 LINES";

answered Jan 8, 2014 at 15:32

Giacomo1968

25.3k11 gold badges78 silver badges106 bronze badges

1 Comment

the tao Over a year ago

I edited to account for your correction, which was right but still missing something. I am so bad with these strings :(

Atul Singh Rajpoot · Accepted Answer · 2014-01-09 12:41:00Z

0

Try with following code:

"LOAD DATA LOCAL INFILE '.$file_location.' INTO TABLE business.table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STARTING BY '' IGNORE 1 LINES";

and share your result should it worked for you or not?

edited Jan 9, 2014 at 12:41

answered Jan 8, 2014 at 15:53

Atul Singh Rajpoot

4392 silver badges9 bronze badges

Collectives™ on Stack Overflow

MySQL string returning error

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related