The technique I've settled on is this: mysql blah blah blah < the_select_query.sql > the_output_i_want.txt
That gives you a tab-delimited text file with column headings. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: LAMP [mailto:l...@afan.net] >Sent: Saturday, January 08, 2011 6:05 PM >To: mysql@lists.mysql.com >Subject: export result from select statement > >Hi guys, >I wonder how to store to csv or txt file result from SELECT query? >not a whole table nor database. Just results from SELECT query. >Usually I use MySQL Query Browser and Export feature, but in this >case I don't have access with MySQL Query Browser. Though, I have a >command line access. >I found on one place something like >#SELECT 2+2 into outfile '/path/to/specific/directory/test.csv'; >Though, it doesn't work?!? > >Thanks. > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
