sqlite3 csv dump export import - Jakob2/qt-cpp-opengl-3d-drawer GitHub Wiki

export
sqlite3 3dg;
sqlite> .mode csv
sqlite> .headers on
sqlite> .out poly.dmp
sqlite> select * from poly;
(sqlite> .exit)

import (not tested)
.mode insert <target_table_name>
.out file.sql