"Android" Sqlite3 command detailed

Sqlite3 Common Commands

The Sqlite3 command has "." Match as a prefix.

Basic operations 1, create or open a database sqlite3 xxx.db

Open if xxx.db is present if not, the Xxx.db file will not appear until you create the command that creates the table at this time.

Create a XXX.DB database

 
sqlite3 xxx.db

CREATE TABLE record(id integer primary key autoincrement,time varchar(20),name varchar(30),count int);

2. View table structure

sqlite>. Schema record

View table record structure

3. View all Tables

Sqlite>. Tables

4. View the database

sqlite>. Databases

5. Execute SQL Script

sqlite>. Read Insert.sql

6. View Help

Sqlite>. Help

7. Backing Up the database

Sqlite>. Backup C:/users/ghost/desktop/lemo/xx.sql

Data deletion and modification

1. Create a table

CREATE TABLE record (ID integer primary key autoincrement,time varchar (), name varchar (), Count int);

2, modify the table

3. Inserting data

INSERT into record (Time,name) VALUES (' 20160124 ', ' Xu Fengyan ');

4. Query data

SELECT * from record;

5. Change data

Update record set name= ' G ' where id=1;

6. By deleting

Delete from record where id=1

.backup ?DB? FILE           Backup DB (default "main") to FILE
.bail ON|OFF                  Stop after hitting an error.  Default OFF
.databases                     List names and files of attached databases
.dump ?TABLE? ...          Dump the database in an SQL text format
                                 If TABLE specified, only dump tables matching
                                 LIKE pattern TABLE.
.echo ON|OFF               Turn command echo on or off
.exit                          Exit this program
.explain ?ON|OFF?          Turn output mode suitable for EXPLAIN on or off.
                                 With no args, it turns EXPLAIN on.
.header(s) ON|OFF          Turn display of headers on or off
.help                          Show this message
.import FILE TABLE        Import data from FILE into TABLE
.indices ?TABLE? Show names of all indices
                                If TABLE specified, only show indices for tables
                                 matching LIKE pattern TABLE.
.log FILE|off                  Turn logging on or off.  FILE can be stderr/stdout
.mode MODE ?TABLE?         Set output mode where MODE is one of:
                                 csv      Comma-separated values
                                 column   Left-aligned columns.  (See .width)
                                 html     HTML <table> code
                                 insert   SQL insert statements for TABLE
                                 line     One value per line
                                 list     Values delimited by .separator string tabs     Tab-separated values
                                 tcl      TCL list elements
.nullvalue STRING          Print STRING in place of NULL values
.output FILENAME           Send output to FILENAME
.output stdout                 Send output to the screen
.prompt MAIN CONTINUE     Replace the standard prompts
.quit                          Exit this program
.read FILENAME             Execute SQL in FILENAME
.restore ?DB? FILE         Restore content of DB (default "main") from FILE
.schema ?TABLE? Show the CREATE statements
                                 If TABLE specified, only show tables matching
                                 LIKE pattern TABLE.
.separator STRING          Change separator used by output mode and .import
.show                          Show the current values for various settings
.stats ON|OFF              Turn stats on or off
.tables ?TABLE? List names of tables
                         If TABLE specified, only list tables matching
                         LIKE pattern TABLE.
.timeout MS            Try opening locked tables for MS milliseconds
.vfsname ?AUX? Print the name of the VFS stack
.width NUM1 NUM2 ...   Set column widths for "column" mode
.timer ON|OFF          Turn the CPU timer measurement on or off

Over

"Android" Sqlite3 command detailed