Thanks Andy, that will do! I don't have a manual, using the open source MySQL. I do have a book (New Riders "MySQL") but was looking for "deliminated" not "terminated." Found it now. Thanks again for the help.
Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***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.*** -----Original Message----- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 8:06 AM To: Mysql List Subject: RE: CSV Formated output Jeff, Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ',' See the manual for more info. Andy > -----Original Message----- > From: Jeff McKeon [mailto:[EMAIL PROTECTED] > Sent: 03 July 2003 12:38 > To: [EMAIL PROTECTED] > Subject: CSV Formated output > > > Is there a way to output the results of a select query into a CSV or > Comma Deliminated format? > > Thanks, > > Jeff McKeon > IT Manager > Telaurus Communications LLC > [EMAIL PROTECTED] > (973) 889-8990 ex 209 > > ***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.*** > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]