-- set output to a csv file sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; -- revert output to stdout sqlite> .output stdout