sqlite-commands (such as. help)

Command:

Example

Output Help information Sqlite>.help

(Note the character '. ' Before the command) ：

View database file Information command: sqlite>.database

View creation statements for all tables: Sqlite>.schema

View the creation statement for the specified table: Sqlite>.schema table_name

Sqlite>. Schema

CREATE TABLE mytable (ID integer primary key,value text); CREATE TABLE TBL1 (one varchar (ten), smallint, email text ' Collate nocase, others text '); CREATE INDEX Test_idx on TBL1 (both); CREATE VIEW Tbl1view as SELECT * from TBL1; CREATE TABLE t_table1 (name text,age interger, num); CREATE INDEX T_table1_index on T_table1 (name);

Table contents are listed as SQL statements: Sqlite>.dump table_name

To set the delimiter for displaying information: Sqlite>.separator symble

Example: Set display information to ': ' to separate sqlite>.separator:

Set display mode: Sqlite>.mode mode_name

Example: The default is List, set to column, and other modes are available through. Help view mode related content Sqlite>.mode columnsqlite> select * from T_table1;name Num----------------------------xinxin 8 1wangwu 20lisi 20libai 200

Set the display width for each column: Sqlite>.width width_value

Example: Set width to 2sqlite>.width 2

Lists the configuration for the current display format: sqlite>.show

Sqlite>. Show Echo:off explain:off headers:on mode:columnnullvalue: "" Output:stdoutseparator: "|" Stats:on width:

Exit the SQLite Terminal command: Sqlite>.quit or Sqlite>.exit

sqlite-commands (such as. help)