Export from sqlite to csv using shell script

by

Instead of the dot commands, you could use sqlite3 command options:

sqlite3 -header -csv my_db.db "select * from my_table;" > out.csv

This makes it a one-liner.

Also, you can run a sql script file:

sqlite3 -header -csv my_db.db < my_script.sql > out.csv

Use sqlite3 -help to see the list of available options.

More Related Contents:

  1. SQLite: How do I save the result of a query as a CSV file?
  2. near “varchar”: syntax error [closed]
  3. How do I make an UPDATE while joining tables on SQLite?
  4. How do I rename a column in a SQLite database table?
  5. How to set Sqlite3 to be case insensitive when string comparing?
  6. Escape single quote character for use in an SQLite query
  7. Update with Join in SQLite
  8. Can I read and write to a SQLite database concurrently from multiple connections?
  9. How do I store and retrieve a blob from sqlite?
  10. SQLite error ‘attempt to write a readonly database’ during insert?
  11. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  12. Store boolean value in SQLite
  13. Can SQLite support multiple users?
  14. Python CSV to SQLite
  15. SQLite add Primary Key
  16. Encrypted cookies in Chrome
  17. How delete table inner join with other table in Sqlite?
  18. Create table in SQLite only if it doesn’t exist already
  19. How do DATETIME values work in SQLite?
  20. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  21. Is there a boolean literal in SQLite?
  22. sqlite get ROWID
  23. svn cleanup: sqlite: database disk image is malformed
  24. Truncate a SQLite table if it exists?
  25. SQLite for large data sets?
  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