SQLite: How do I save the result of a query as a CSV file?

by

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> select * from tbl1;
sqlite> .output stdout

More Related Contents:

  1. Export from sqlite to csv using shell script
  2. How do I rename a column in a SQLite database table?
  3. How do I check in SQLite whether a table exists?
  4. Importing a CSV file into a sqlite3 database table using Python
  5. Accessing an SQLite Database in Swift
  6. Import CSV to SQLite
  7. Difference between 2 dates in SQLite
  8. Select random row from a sqlite table
  9. Import .csv file to Sqlite in Android
  10. Sqlite primary key on multiple columns
  11. Can SQLite support multiple users?
  12. Python CSV to SQLite
  13. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  14. How to implement Export sqlite To excel/csv file in android?
  15. How to generate all dates between two dates
  16. SQLITE_BUSY The database file is locked (database is locked) in wicket
  17. Does it matter what extension is used for SQLite database files?
  18. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  19. How do I DROP a constraint from a sqlite (3.6.21) table?
  20. Sqlite over a network share [closed]
  21. SQLite table constraint – unique on multiple columns
  22. Is there a boolean literal in SQLite?
  23. Case sensitive and insensitive like in SQLite
  24. svn cleanup: sqlite: database disk image is malformed
  25. Truncate a SQLite table if it exists?
  26. SQLite database supporting Unicode data
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment