MySQL Forums
Forum List  »  CSV Storage Engine

Storing the CSV file in my desired location.
Posted by: Soumik Basu
Date: September 04, 2007 06:27AM

I am using MySQL as a backend tool in my application.I have to export the resultset in CSV format so I am using the query:
"Select * into OUTFILE 'batch' FIELDS TERMINATED BY ',' from Orders ";
I am storing my resultset in the file "batch" but I cannot give a path to store the file(batch) in my desired location,by default it is getting stored in my database folder only.I want to store this file in a separate folder other than my database folder.

I need urgent help regarding this issue.
Thanks in regards.

Options: ReplyQuote

Written By
Storing the CSV file in my desired location.
September 04, 2007 06:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.