exporting from MYSQL

[flofromdromtine]

I am new to SQL trying to export a table from MYSQL using a simple select query:
SELECT *
INTO OUTFILE "C :\SQL_Output\tmp1.txt"
FROM sneem;
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]

try this -- INTO OUTFILE '/SQL_Output/tmp1.txt'

[flofromdromtine]

Brill ! First time using Sitepoint and got an answer that worked. Many thanks.