How to export the results of my query to csv file. Sqlite - Stack Overflow

From here and d5e5's comment: You'll have to switch the output to csv-mode and switch to file output. sqlite> .mode csv sqlite> .output test.csv sqlite> ...

stackoverflow.com