#mysql -username -p -e "select * from table_name where id=123" > '/home/me/test/test.txt'
On Mon, Jan 10, 2011 at 8:15 AM, LAMP <l...@afan.net> wrote: > maybe it's "clear" to other but it's pretty unclear. > #mysql -username -p "select * from table_name where id=123" > > '/home/me/test/test.txt' > actually doesn't work?!? > > > > > 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: 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 >>> >>> >> >> >> >> >> >> >> > >