Load data Infile @variable into infile error

Question

I want to use a variable as the file name in Load data Infile. I run a below code:

Set @d1 = 'C:/Users/name/Desktop/MySQL/1/';
Set @d2 = concat( @d1, '20130114.txt');
load data local infile  @d2  into table Avaya_test (Agent_Name, Login_ID,ACD_Time);

Unfortunately after running, there is a error with the commment like below: "Error Code: 1064. You have an error in your SQL syntax ......"

Variable "@D2" is underlined in this code so it means that this error is caused by this variable.

Can you help me how to define correctly a variable of file name in LOAD DATA @variable infile ?

Thank you.

Answer 1

A citation from MySQL documentation:

The file name must be given as a literal string. On Windows, specify backslashes in path names as forward slashes or doubled backslashes. The character_set_filesystem system variable controls the interpretation of the file name.

That means that it can not be a parameter of a prepared statement, stored procedure, or anything "server-side". The string/path evaluation must be done client side.