Sqlite3 command Line

1. View version Information
Sqlite3-verion

2. Create/Open Database
Sqlite3 database name
Example: Sqlite3 test.db
If Test.db does not exist, create
If present, open the
3. Exit
. q/.exit
4. List the current display format
. Show
. Output/home/csgec/msql.sql//Rewrite the output to the specified file
. Headers on
. Mode column

5. See what tables are in the database
. tab

6. Display the table structure (that is, the CREATE statement of the view table)
. schema [table name]

7. Data backup
1.CP xxx.db Xxx.db.bak Backup Database
2.. backup filename backs up the database for the specified file
3. Backup table
1.. output/home/csgec/table_user.txt
2.. dump User_table
3.. q

4. Restore a backed up table
. read/home/csgec/table_user.txt

8. Save the personal configuration in the. sqliterc file
Vim ~/.sqliterc
. Headers on
. Mode column

9. Help
. Help

Sqlite3 command Line