How to output MySQL query results in CSV format?

Question

How to output MySQL query results in CSV format?

Answer 1

You can use terminal/command prompt and use the following method;
"SELECT * FROM MyDatabse.dbo.MyTable" queryout C:\MySqlData.csv -c -t',' -T -S .\SQLEXPRESS