快速上手:
- adb shell
- cd 到db所在目录
- sqlite3 user_info.db
- .tables 列出db中所有的表
- 接下来用SQL语句吧,骚年!
小技巧:
-
.mode column 查询结果以列表形式显示,方便查看 -
.header on 查询结果会把列名放在第一行,
语法示例:
select * from [tablename] where [columnname] is not "" and [columnname] != [value]
select * from Student where monkey is not "" and sexy != 'female'
参考资料:
http://www.server110.com/sqlite/201308/796.html
http://www.sqlite.org/lang.html
Android adb shell下查看sqlite数据库