Eric Bergen wrote:
select into outfile is the correct way. What do you mean by doesn't
work? Does it give you an error?
It was an issue with permissions :-)
Thanks
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