admin管理员组文章数量:1130349
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
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数据库 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://it.en369.cn/jiaocheng/1724694773a504260.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论