I'm on a local windows machine. The MySQL DB is on a CentOS machine elsewhere on the same local network. I want to output the results of the query that I'm typing directly into Putty into an Excel (or csv) file elsewhere on the local network. How would I do this?
I tried something like
mysql> select * from table > \\server\my_documents\output.csv
but no luck.