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';