SQLite .mode 顯示模式

.mode MODE

設(shè)置輸出模式，MODE 可以是下列之一：

csv 逗號(hào)分隔的值
column 左對(duì)齊的列
html HTML 的 <table> 代碼
insert TABLE 表的 SQL 插入（insert）語句
line 每行一個(gè)值
list 由 .separator 字符串分隔的值
tabs 由 Tab 分隔的值
tcl TCL 列表元素

創(chuàng)建表：

CREATE TABLE person(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, AGE INTEGER NOT NULL, PHONE_NUMBER TEXT NOT NULL);
insert into person(NAME,AGE,PHONE_NUMBER) values('ZHANG SAN', 20, '13012345678');
insert into person(NAME,AGE,PHONE_NUMBER) values('LI SI', 22, '15055550000');
insert into person(NAME,AGE,PHONE_NUMBER) values('WANG WU', 24, '17077770000');

1、默認(rèn)模式：list，（實(shí)際運(yùn)行結(jié)果和說明寫的不一樣）這里是以 | 分割

sqlite> .mode
current output mode: list
sqlite> select * from person;
ID|NAME|AGE|PHONE_NUMBER
1|ZHANG SAN|20|13012345678
2|LI SI|22|15055550000
3|WANG WU|24|17077770000

2、.csv模式，該模式列間以逗號(hào)分隔

sqlite> .mode csv
sqlite> select * from person;
ID,NAME,AGE,PHONE_NUMBER
1,"ZHANG SAN",20,13012345678
2,"LI SI",22,15055550000
3,"WANG WU",24,17077770000

3、column模式，該模式最為常用，每列數(shù)據(jù)左對(duì)齊，關(guān)鍵字和數(shù)據(jù)用橫線分隔，顯示起來比較直觀清晰

sqlite> .mode column
sqlite> select * from person;
ID  NAME       AGE  PHONE_NUMBER
--  ---------  ---  ------------
1   ZHANG SAN  20   13012345678
2   LI SI      22   15055550000
3   WANG WU    24   17077770000

4、html模式該模式將表格以html格式輸出

sqlite> .mode html
sqlite> select * from person;

<TR>
    <TH>ID</TH>
    <TH>NAME</TH>
    <TH>AGE</TH>
    <TH>PHONE_NUMBER</TH>
</TR>
<TR>
    <TD>1</TD>
    <TD>ZHANG SAN</TD>
    <TD>20</TD>
    <TD>13012345678</TD>
</TR>
<TR>
    <TD>2</TD>
    <TD>LI SI</TD>
    <TD>22</TD>
    <TD>15055550000</TD>
</TR>
<TR>
    <TD>3</TD>
    <TD>WANG WU</TD>
    <TD>24</TD>
    <TD>17077770000</TD>
</TR>

5、insert模式該模式將表中每條數(shù)據(jù)以SQL語句輸出

sqlite> .mode insert
sqlite> select * from person;
INSERT INTO "table"(ID,NAME,AGE,PHONE_NUMBER) VALUES(1,'ZHANG SAN',20,'13012345678');
INSERT INTO "table"(ID,NAME,AGE,PHONE_NUMBER) VALUES(2,'LI SI',22,'15055550000');
INSERT INTO "table"(ID,NAME,AGE,PHONE_NUMBER) VALUES(3,'WANG WU',24,'17077770000');

6、line模式，該模式將每行的每個(gè)值用賦值的形式輸出（實(shí)例較長，只列出部分）

sqlite> .mode line
sqlite> select * from person;
          ID = 1
        NAME = ZHANG SAN
         AGE = 20
PHONE_NUMBER = 13012345678

          ID = 2
        NAME = LI SI
         AGE = 22
PHONE_NUMBER = 15055550000

          ID = 3
        NAME = WANG WU
         AGE = 24
PHONE_NUMBER = 17077770000

7、tabs模式，該模式列間以tab鍵分隔，注意：tab鍵默認(rèn)占8個(gè)字符，故第一行數(shù)據(jù)的“California”占了兩個(gè)tab，所以“20000.0”只能在下一個(gè)tab中輸出，而第二行則是每列數(shù)據(jù)各占一個(gè)tab

sqlite> .mode tabs
sqlite> select * from person;
ID      NAME    AGE     PHONE_NUMBER
1       ZHANG SAN       20      13012345678
2       LI SI   22      15055550000
3       WANG WU 24      17077770000

8、tcl模式，該模式的關(guān)鍵字和各數(shù)據(jù)均用雙引號(hào)引起，列間以空格分隔

sqlite> .mode tcl
sqlite> select * from person;
"ID" "NAME" "AGE" "PHONE_NUMBER"
"1" "ZHANG SAN" "20" "13012345678"
"2" "LI SI" "22" "15055550000"
"3" "WANG WU" "24" "17077770000"

posted @ 2022-04-04 14:06 Brickert Views(599) Comments(0) 收藏舉報(bào)

刷新頁面返回頂部

Brickert

SQLite .mode 顯示模式

公告