Home / Questions / 277159
Accepted
FrEqDe
Asked: 2020-07-06 17:25:55 +0800 CST 2020-07-06 17:25:55 +0800 CST

sqlite3 not found in Android Studio

  • 772

I am trying to connect through the console to the phone where I have my application installed so that I can query the database with SQL.

I was watching a tutorial in the show how it is done, however it did not work for me, I looked for extra information and found another example that does the same thing, so I tried again if I did something wrong, but the same error appears.

The steps are the following:

  1. go to directory<sdk>/platform-tools/
  2. Writeadb shell
  3. Writesqlite3 data/data/<package>/databases/<nombre-base-de-datos>

After this the following message should appear:

SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite>

When performing step 3 I get the error sqlite3: not found

The only thing that I have noticed that is different is that after step 2 in the tutorials the console prompt is # , root@android:/ #while in mine it is $ , HWANE:/ $, I don't know if that has something to do with it.

android

1 Answers

  1. Best Answer

    If you installed Android Studio, you can find sqlite3 inside /platform-tools.

    If you entered <sdk>/platform-tools/there you can execute sqlite3, you do not need to perform steps 2 and 3.

    This is an example running:

    $ sqlite3 .help

    enter image description here

    • 2