Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I generate an output in CSV format from a database query?

April 26, 2017csv database format output query

0

10 Posted

How can I generate an output in CSV format from a database query?

1 Answer

0

10 Posted

Location: http://www.jguru.com/faq/view.jsp?EID=455207 Created: Jul 15, 2001 Author: Luigi Viggiano (http://www.jguru.com/guru/viewbio.jsp?EID=101985) Question originally posed by Ritu kumar (http://www.jguru.com/guru/viewbio.jsp?EID=314981 CSV stands for “Comma Separated Values”, so just keep any record and separe each field with a comma and each record with a newline (‘\n’). You’ll have a perfect CSV file, easy readable by any program supporting this simple format. It’s very common to put as first line the names of fields.