RE: CSV Formated output - Andy Eastham - com.mysql.lists.mysql

13 messages in com.mysql.lists.mysqlRE: CSV Formated output

From	Sent On	Attachments
Jeff McKeon	03 Jul 2003 04:37
Andy Eastham	03 Jul 2003 05:05
Joe Baptista	03 Jul 2003 05:32
Matthew Smith	03 Jul 2003 05:44
Jeff McKeon	03 Jul 2003 05:49
Jay Blanchard	03 Jul 2003 06:25
Andy Eastham	03 Jul 2003 06:25
Jeff McKeon	03 Jul 2003 07:24
Jeff McKeon	03 Jul 2003 07:31
Jeff McKeon	03 Jul 2003 07:49
Victor Pendleton	03 Jul 2003 08:02
Mark Matthews	03 Jul 2003 08:04
Jeff McKeon	03 Jul 2003 09:37

Subject:	RE: CSV Formated output
From:	Andy Eastham (an...@barllama.demon.co.uk)
Date:	07/03/2003 05:05:24 AM
List:	com.mysql.lists.mysql

Jeff,

Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ','

See the manual for more info.

Andy

-----Original Message----- From: Jeff McKeon [mailto:jmck...@telaurus.com] Sent: 03 July 2003 12:38 To: mys...@lists.mysql.com Subject: CSV Formated output

Is there a way to output the results of a select query into a CSV or Comma Deliminated format?

Thanks,

***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.***