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.
Subject
Views
Written By
Posted
Storing the CSV file in my desired location.
10331
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.