Export data to CSV
Posted by:
Ian Hayes
Date: February 20, 2015 06:33AM
I've been asked to implement a MySQL to CSV file data export facility for a web app page that presents MySQL data in a UI grid. The user has options for filtering and sorting the data shown in the UI grid. There is a SQL query that underpins the data being displayed in the UI.
My initial thoughts were focused on adapting the SQL to append the 'INTO...' clause onto the end of the current query. However, how would I define the name of the CSV file? Is there a standard MySQL folder into which the resulting CSV file extracts are dropped?
How would I find the location of that file? Because in my UI I want to provide that location as a clickable URL link so that the user can download the CSV file.
Equally, how would scenario work in a clustered environment.
Subject
Written By
Posted
Export data to CSV
February 20, 2015 06:33AM
February 20, 2015 08:37AM
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.