I am new to SQL trying to export a table from MYSQL using a simple select query:
INTO OUTFILE "C :\SQL_Output\ mp1.txt"
I get a positive response from the command line:
Query OK, 14 rows affected (0.05 sec)
But there is no output file created! What is the problem?
try this -- INTO OUTFILE '/SQL_Output/tmp1.txt'
Brill ! First time using Sitepoint and got an answer that worked. Many thanks.