select into outfile is the correct way. What do you mean by doesn't work? Does it give you an error?
On Sat, Jan 8, 2011 at 3:04 PM, LAMP <l...@afan.net> wrote: > 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=eric.ber...@gmail.com > > -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org