title: Generating a text file in MYSQL stored procedure
body: <p>I'm new to MySQL, I am trying to create a text file using a stored procedure.  I'm currently at the stage where I have a temporary table that contains all of the records that I want to output to a text file.  I have the following line at the end of my SP, it works in PHPMYAdmin's query but it does not work when part of a stored procedure the code is as follows:</p>
  
  <p>SELECT * into outfile '../../htdocs/VIP/Temp/temp.txt' from tmp_Menu2;</p>
  
  <p>note that tmp_Menu2 is a table that only includes one field of type VARCHAR(1000)</p>
  
  <p>Any help would be greathly appreciated.</p>
  
  <p>Thank you,</p>