hi jeff: what i do - have been doing for year is dump the data you want using the dump proceedure in mysql - then use a simple shell script to convert it to csv - i.e.
cat mysql.dump.file | while read line do field1=`echo "$line" | cut -f1` field2=`echo "$line" | cut -f2` field???=`echo "$line" | cut -f???` echo "\"$field1\",\"$field2\",\"$field???\"" done you can get fancy and write the shell script so you can pass in the number of fields you want. hope that helps joe Joe Baptista - only at www.baptista.god ----------------------------------> NEWS <----------------- //////////B////////// BBC News - Americas //////////B/B/C///// http://bbc.news/2/hi/americas //////B/B/C//////// BBC News about the Americas, in ////////////////// in alternative root format. On Thu, 3 Jul 2003, Jeff McKeon wrote: > 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]
