title: Load data Infile @variable into infile error
body: <p>I want to use a variable as the file name in Load data Infile. I run a below code:</p>
  
  <pre><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);
  </code></pre>
  
  <p>Unfortunately after running, there is a error with the commment like below:
  "Error Code: 1064. You have an error in your SQL syntax ......" </p>
  
  <p>Variable "@D2" is underlined in this code so it means that this error is caused by this variable.</p>
  
  <p>Can you help me how to define correctly a variable of file name in LOAD DATA @variable infile ?</p>
  
  <p>Thank you.</p>