MySQL Forums
Forum List  »  Newbie

Exporting to CSV with Headers
Posted by: Gerard Ang
Date: May 23, 2018 02:13AM

Hi All,

This question might be ask before but I can't seem to get any results from my searches.

I am looking to do a daily export of my database into a CSV file for the consumption of others. The issue is that I am looking to do it either from C# or a batch file running on Windows via Scheduled Task.

The "Select ... Into Outfile" is capable of exporting the data for me but I am missing the headers.

The Table Data Export Wizard does what I require but I don't see any way of calling it from code or batch commands.

The reason why I need something dynamic is because the data required is a few hundred columns wide.

Any help is greatly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Exporting to CSV with Headers
May 23, 2018 02:13AM


Sorry, only registered users may post in this forum.

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.