How can I output MySQL query results in CSV format?

To save the results of a MySQL query as a CSV file, you can use the INTO OUTFILE clause in your query. For example, if you want to save the results of the following query as a CSV file:

SELECT * FROM users;

You can use the following query:

SELECT * FROM users INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

This will save the results of the SELECT query in a CSV file at the specified path. The fields in the file will be separated by commas, and each line will be terminated by a newline character.

Note that this query must be run on the MySQL server, and you must have the appropriate permissions to write to the specified file path. Additionally, the INTO OUTFILE clause is considered a security risk, so you should use it with caution.