在shell中使用Sqlite3

最新推荐文章于 2025-07-15 13:10:20 发布

weixin_33709364

最新推荐文章于 2025-07-15 13:10:20 发布

阅读量794

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 shell python

原文链接：https://my.oschina.net/cuitongliang/blog/153318

本文介绍如何通过adb远程Shell使用sqlite3命令行工具管理Android应用程序创建的SQLite数据库。文中详细解释了如何进入远程Shell并调用sqlite3工具，还介绍了部分实用命令如 .dump 和 .schema 的使用方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

Examining sqlite3 Databases from a Remote Shell

From an adb remote shell, you can use the sqlite3 command-line program to manage SQLite databases created by Android applications. The sqlite3tool includes many useful commands, such as .dumpto print out the contents of a table and .schemato print the SQL CREATE statement for an existing table. The tool also gives you the ability to execute SQLite commands on the fly.

To usesqlite3, enter a remote shell on the emulator instance, as described above, then invoke the tool using thesqlite3command. Optionally, when invokingsqlite3you can specify the full path to the database you want to explore. Emulator/device instances store SQLite3 databases in the folder/data/data/<package_name>/databases/.

Here's an example:

$ adb -s emulator-5554 shell
# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db
SQLite version 3.3.12
Enter ".help" for instructions
.... enter commands, then quit...
sqlite> .exit

Once you've invokedsqlite3, you can issuesqlite3commands in the shell. To exit and return to the adb remote shell, useexitorCTRL+D.

转载于:https://my.oschina.net/cuitongliang/blog/153318