how can u backup the data in your db to a csv using sql?

Answer 1

>sqlite3 database.sqlite
sqlite> .headers on
sqlite> .mode csv
sqlite> .output backup.csv
sqlite> SELECT * FROM tablename;
sqlite> .quit

Answer 2

when your query is fulfilled, you can save as CSV format. you would want to view query as "grid".

Answer 3

bcp database.schema.tablename | out 'filename .csv'