mysqldump --tab=/tmp --no-create-info --fields-terminated-by=',' database table Should do the trick. This will create a file called /tmp/table.txt, containing the data. Use --where=".." to select from fields. For more complext selects, look at select field1, field2 into outfile '/path/to/file' from ... Regards Quentin -----Original Message----- From: Jason Terry [mailto:[EMAIL PROTECTED]] Sent: Friday, 26 January 2001 10:54 To: [EMAIL PROTECTED] Subject: How do I make a CSV dump Anybody have a quick way to make a CSV dump of a SELECT? If MySQL can't do it directly is there an easy way in PERL? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php