SQLite

sudo apt update
sudo apt install sqlite3

# 如果 test.db 不存在，会自动创建。
sqlite3 test.db

.tables
.schema
.schema table_name
PRAGMA table_info(table_name);

.headers on
.mode column

.schema table_name

.quit

.dbinfo

sqlite3 db.sqlite .dump > dump.sql

sqlite3 db.sqlite -header -csv "select * from table;" > data.csv

sqlite3 your_sqlite_database.db ".dump your_table_name" > your_table_name.sql

sqlite3 your_sqlite_database.db <<EOF
.mode insert your_table_name
.output your_table_fields.sql
SELECT field1, field2 FROM your_table_name;
EOF

$ sqlite3 db.sqlite

sqlite>.output db.sql
sqlite>.dump
sqlite>.quit

sqlite3 your_sqlite_database.db .dump > exported_data.sql

$ sqlite new.sqlite

sqlite>.read db.sql
sqlite>.quit