- 首先, 登录官网下载数据库工具 SQLite Download Page
- 安装sqlite
- 运行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>
- 常用命令:
.open + 数据库名称
.table
.mode column
.head on
.timer on
Original: https://blog.csdn.net/weddell/article/details/122303008
Author: citip
Title: Windows下如何查看sqlite数据库
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/816911/
转载文章受原作者版权保护。转载请注明原作者出处!