select into oufile does not work

Question

Why would the following query appear to run but I never can find the file outfile?

      select * 
      INTO OUTFILE 'outfile.csv'
      FIELDS TERMINATED by ','
      LINES TERMINATED BY '\n'
      from nGrams

I have MySQL 5.5 and I am running my queries from MySQL Workbench

any errors? Can you post execution results after you run this query? — rs., Dec 06 '12 at 19:08
Sorry, I changed something and now I do not get an error. I just cannot find the file. I have tried specific directories and still I do not see it. — CodeKingPlusPlus, Dec 06 '12 at 19:18

score 0 · Accepted Answer · answered Dec 06 '12 at 19:29

0

The file 'outfile.csv' will appear in the same directory as your database. On windows this is C:\ProgramData\MySQL\MySqlServerX.X\db_name

answered Dec 06 '12 at 19:29

CodeKingPlusPlus

1 Answers1