MySQL Forums
Forum List  »  Newbie

How to Export Query Result to CSV?
Posted by: Ryan Shuell
Date: July 12, 2013 07:48AM

I have my query working fine. I'm trying this to export the results to a CSV file.

SQL here . . .
INTO OUTFILE '\\\machine-name\\testfile.csv'

I'm working on a VM. Is there some kind of restriction that would prevent this from working on a VM? I have full super-user rights on this machine (I can do anything). Other data export processes from other technology tools work just fine.

One thing that I noticed is that you seem to need ‘\\’ to get one ‘\’ which is the same as C#. In SQL Server, you just use one back slash to achieve the same thing.

Thanks everyone!!

Options: ReplyQuote

Written By
How to Export Query Result to CSV?
July 12, 2013 07:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.