Question :
I’m trying to figure out the syntax to export the results of a MySQL query to the desktop as a CSV file via SSH. Here’s what I’m trying:
SELECT * INTO OUTFILE 'C:UsersJim SmithDesktopzyzyz.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
Answer :