mysql Can't create/write to file '/home/results.csv' (Errcode: 13 "Permission denied")
snippet in sql

mysql Can't create/write to file '/home/results.csv' (Errcode: 13 "Permission denied")

user4283

-- If you are using linux,

SELECT id, filename
INTO OUTFILE '/tmp/results.csv'
FROM attachments
-- and find the csv file /tmp