I ma connected to the MySQL Server by a trusted connection on a remote PC using work bench
I am using the Select * into OUTFILE statement
into OUTFILE 'C:\\testexport1.xls'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Open in new window
This is working but is exporting the file to the server instead of my PC, how do I get the file to be exported to my PC instead of the server.
Does the -e mean echo in a command prompt?
I use workbench for all operations, does the above mean using the command prompt?