How do I dump the data of some SQLite3 tables?

by

You’re not saying what you wish to do with the dumped file.

To get a CSV file (which can be imported into almost everything)

.mode csv 
-- use '.separator SOME_STRING' for something other than a comma.
.headers on 
.out file.csv 
select * from MyTable;

To get an SQL file (which can be reinserted into a different SQLite database)

.mode insert <target_table_name>
.out file.sql 
select * from MyTable;

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite Reset Primary Key Field
  4. Update table values from another table with the same user name
  5. FULL OUTER JOIN with SQLite
  6. SQLite – How do you join tables from different databases?
  7. Does SQLite3 not support foreign key constraints?
  8. SQLite – ORDER BY RAND()
  9. Query to get records based on Radius in SQLite?
  10. How do I add a foreign key to an existing SQLite table?
  11. How to use SQL Order By statement to sort results case insensitive?
  12. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  13. sqlite alter table add MULTIPLE columns in a single statement
  14. Is there AUTO INCREMENT in SQLite?
  15. Drop all tables command
  16. Get month from DATETIME in sqlite
  17. How do I import .sql files into SQLite 3?
  18. sqlite equivalent of row_number() over ( partition by …?
  19. String concatenation does not work in SQLite
  20. Android multiple databases open
  21. Unfindable SQLite Syntax Error
  22. SQLite3 UNIQUE constraint failed error
  23. Does SQLite3 have prepared statements in Node.js?
  24. SQlite: select into?
  25. SQL error: misuse of aggregate
  26. SQLite query, ‘LIKE’
  27. How to use a calculated column by another calculated column
  28. UPSERT *not* INSERT or REPLACE
  29. Drop column from SQLite table
  30. converting int to real in sqlite

Leave a Comment