How do I dump the data of some SQLite3 tables?

Question

How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)? The dump should be in SQL format, as it should be easily re-entered into the database later and should be done from the command line. Something like

sqlite3 db .dump

but without dumping the schema and selecting which tables to dump.

Answer 1

To get a CSV file, try using below code:

.mode csv 

-- use '.separator SOME_STRING' for something other than a comma.

.headers on 

.out file.csv 

select * from MyTable;

But, if you want to reinsert into a different SQLite database then use below code:

.mode insert <target_table_name>

.out file.sql 

select * from MyTable;