Generating a text file in MYSQL stored procedure
- by Pablo
Hi,
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:
SELECT * into outfile '../../htdocs/VIP/Temp/temp.txt' from tmp_Menu2;
note that tmp_Menu2 is a table that only includes one field of type VARCHAR(1000)
Any help would be greathly appreciated.
Thank you,