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 sensorDatasqlite> select * from devices; ip|10|{"1":"A","2":"B","3":"C"}|||||0sqlite> .mode column sqlite> .head onsqlite> select * from devices; ip port dev info lastConnection lastCommand alarmType status -- ---- ------------------------- ---- -------------- ----------- --------- ------ ip 10 {"1":"A","2":"B","3":"C"} 0sqlite> .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