MySQL - Exported table to cvs file. Where did it go?


#1

Hi there. New to Cloud 9 but really like it. I have a dumb question:

Working with MySQL. I wanted to create a CSV file so that later on I could download it to my computer. I executed the following statement:

mysql> (SELECT “ID”, “UserID”, “DeviceNbr”,“Hnbr”,“Category”,“Description”,“SeverityLevel”)
-> UNION
-> (SELECT ID, UserID, DeviceNbr,Hnbr,IFNULL(Category, " “),Description,SeverityLevel
-> FROM Hazards
-> INTO OUTFILE “Hazards.csv”
-> FIELDS ENCLOSED BY '”’ TERMINATED BY “;” ESCAPED BY ‘"’
-> LINES TERMINATED BY “\r\n”) ;
Query OK, 55 rows affected (0.00 sec)

Everything ran OK, but when I looked in my current directory I could not find file ‘Hazards.csv’. I though the export would create the file in my current folder.

Couldn’t find the file in my workspace. Where is my Hazards.csv file located? Thanks.