MySQL concat variable error

Question

I got the error saying:

ERROR 1064 (42000): 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 '@my_directory + @my_file INTO TABLE mytable FIELDS TERMINATED BY ',' E' at line 1

for the following code:

    Set @my_directory = 'my directory';
    Set @my_file = 'my file.csv';

    LOAD DATA INFILE @my_directory + @my_file 
    INTO TABLE mytable 
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    LINES TERMINATED BY '\n' IGNORE 1 LINES;

I want to have a seperate directory and file variable, concat them, get the full filename and load a file.

I also tried concat(@my_directory, @my_file1) but still got the same error.

I am using MySQL 5.6 with MySQL Workbench.

Please read the rest of the error message: it says the exact point of your code where unexpected stuff was found. — Álvaro González
– Álvaro González, Commented Jul 29, 2014 at 17:40
possible duplicate of Parameterizing file name in MYSQL LOAD DATA INFILE — Álvaro González
– Álvaro González, Commented Jul 30, 2014 at 16:59
I've ran your code in my local server and added the full error message into the question. As you can see, it points out the exact bit of the query that's invalid. Error messages are intended as a help for the programmer so it never helps to just dismiss them. — Álvaro González
– Álvaro González, Commented Jul 30, 2014 at 17:05

Community · Accepted Answer · 2017-05-23 12:11:39Z

1

I think MySQL does not support it.

https://stackoverflow.com/a/14905351/3662004

http://bugs.mysql.com/bug.php?id=39115

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Jul 29, 2014 at 17:43

Barto

3773 silver badges11 bronze badges

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

3 Comments

John Ruddell Over a year ago

probably should not write this as an answer as it is identical to another answer. rather just point it out in a comment and we can mark as duplicate

Barto Over a year ago

Sorry if I do not use the system properly. I do not have 50 reputation so I can not comment. What should I have done?

John Ruddell Over a year ago

my bad. didn't know you weren't able to comment. generally posting someone else's answer is a huge nono... but i guess its cool. i'll +1 so you are over 50 :)

Collectives™ on Stack Overflow

MySQL concat variable error

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related