Re: How do I make a CSV dump
If you're running windows go to my.anse.de his client will do it. Scott At 02:54 PM 1/25/2001 -0700, Jason Terry wrote: 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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
Re: How do I make a CSV dump
As will the urSQL Utility (MS Windows): http://www.urbanresearch.com/ursql urSQL can export query results in a variety of formats: - HTML - CSV - Excel - Word - Text Depending on your data, you might also be able to use the SELECT INTO OUTFILE syntax: select * into outfile "tableout.txt" fields terminated by ',' enclosed by '"' lines terminated by '\n' from tableout; This should give you a file with each field enclosed with quotes and separated by commas, with each row delimited by a \n: "col1row1","col2row1","col3row1","col4row1","col5row1" "col1row2","col2row2","col3row2","col4row2","col5row2" "col1row3","col2row3","col3row3","col4row3","col5row3" See the manual: http://www.mysql.com/doc/S/E/SELECT.html On Thu, 25 Jan 2001, Scott Baker wrote: If you're running windows go to my.anse.de his client will do it. Scott At 02:54 PM 1/25/2001 -0700, Jason Terry wrote: 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
RE: How do I make a CSV dump
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