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 :-)
> 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