Output data from a sqlite database to a csv file

	sqlite> .mode csv
	sqlite> .output filename.csv
	sqlite> select * from tablename;
	sqlite> .output stdout

view raw outputCSV.sqlite hosted with ❤ by GitHub