title: can I use a variable to specify OUTFILE in mysql
body: <p>Is there a way to do something like the following ? which doesn't work but shows what I want to do</p>
  
  <pre><code>SET @OutputPath = '/Users/jo/Documents'
  SET @fullOutputPath = CONCAT(@OutputPath,'/','filename.csv')
  SET @fullOutputPath2 = CONCAT(@OutputPath,'/','filename2.csv')
  
  SELECT * INTO OUTFILE @fullOutputPath
  FIELDS TERMINATED BY ',' 
  OPTIONALLY ENCLOSED BY '"'
  FROM database.tableName;
  
  SELECT * INTO OUTFILE @fullOutputPath2
  FIELDS TERMINATED BY ',' 
  OPTIONALLY ENCLOSED BY '"'
  FROM database.tableName2;
  </code></pre>