How to write output of SQL query to a text file ?

Run the SQL command with SELECT...INTO clause :

SELECT ...

INTO OUTFILE "/tmp/out.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'

FROM  ...

WHERE ...