flofromdromtine — 2010-03-20T06:49:26-04:00 — #1
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?
r937 — 2010-03-20T07:21:13-04:00 — #2
try this -- INTO OUTFILE '/SQL_Output/tmp1.txt'
flofromdromtine — 2010-03-20T07:54:29-04:00 — #3
Brill ! First time using Sitepoint and got an answer that worked. Many thanks.