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