I second Jerry's recommendation. It always works like a charm for me. - michael dykman
On Sun, Jan 9, 2011 at 2:44 PM, Jerry Schwartz <je...@gii.co.jp> wrote: > 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=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
