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 <lamp@stripped> 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
> I found on one place something like
> #SELECT 2+2 into outfile '/path/to/specific/directory/test.csv';
> Though, it doesn't work?!?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1