Search code examples
mysqlselectselect-intoselect-into-outfile

select into oufile does not work

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

Solution

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