admin 管理员组

文章数量: 887021

1. 首先, 登录官网下载数据库工具 SQLite Download Page

2. 安装sqlite

 3. 运行sqlite3.exe

SQLite version 3.36.0 2021-06-18 18:36:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open xph.sqlite
sqlite> .table

devices     sensorData
sqlite> select * from devices;
ip|10|{"1":"A","2":"B","3":"C"}|||||0
sqlite> .mode column
sqlite> .head on

sqlite> select * from devices;
ip  port  dev                        info  lastConnection  lastCommand  alarmType  status
--  ----  -------------------------  ----  --------------  -----------  ---------  ------
ip  10    {"1":"A","2":"B","3":"C"}                                                0
sqlite> .timer on
sqlite> select * from devices;

ip  port  dev                        info  lastConnection  lastCommand  alarmType  status
--  ----  -------------------------  ----  --------------  -----------  ---------  ------
ip  10    {"1":"A","2":"B","3":"C"}                                                0
Run Time: real 0.004 user 0.000000 sys 0.000000
sqlite>

 4. 常用命令:

.open + 数据库名称

.table

.mode column

.head on

.timer on

本文标签: 数据库 Windows sqlite