sqlite 常用命令

发表于 更新于 分类于

dump database

1
2
3
4
sqlite3 <database_file>
.output <dump_text_file>
.dump
.exit

dump table

1
2
3
.output <dump_text_file>
.dump <table_name>
.exit

dump table structure

1
2
3
.output <dump_text_file>
.schema
.exit

dump data of a table into a text

1
2
3
4
.mode insert
.output <dump_text_file>
.dump <table_name>
.exit
1
.read <dump_text_file>