From: Michael Dykman Date: January 9 2011 8:01pm Subject: Re: export result from select statement List-Archive: http://lists.mysql.com/mysql/224011 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 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: jerry@stripped > Web site: www.the-infoshop.com > >>-----Original Message----- >>From: LAMP [mailto:lamp@stripped] >>Sent: Saturday, January 08, 2011 6:05 PM >>To: mysql@stripped >>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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Djerry@stripped.= jp > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.