Sqlite3 command Overview

(1) enter the database:

 

Sqlite3 database name.

 

(2) help:

 

. Help

 

(3) display database information:

 

. Databases

 

(4) display tables in the database:

 

. Tables

 

(5) display table structure:

 

. Schema table name

 

(6) Exit the database:

 

. Exit or. Quit

 

(7) set the display format of select statement output results:

 

. Mode format (CSV, column, HTML, insert, line, list, tabs, TCL) [Table name]

 

(8) set the delimiter between columns of select statement output results:

 

. Separator string.

 

(9) output the result to the platform:

 

. Output stdout

 

(10) output the result to the file:

 

. Output file name.

 

(11) set the default display character of the null value after the SELECT statement is entered:

 

. Nullvalue string.

 

(12) output or disable logs:

 

. Log File Name | off

 

(13) back up the database:

 

. Backup Database Name (name) file name. DB

 

(14) set whether the output result of the SELECT statement has a field name:

 

. Header on | off

 

(15) export:

 

Sqlite3 database name. DB ". Dump"> out. SQL

 

(16) import:

 

Sqlite3 database name. DB <out. SQL