How to Export Query Result to CSV?

[Ryan Shuell]

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!!