How can you export the results of a SQL query to a CSV file using the MySQL command-line tool?

SELECT * FROM products

INTO OUTFILE '/path/to/output.csv'

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n';