1

I want to do SQLite command like sqlite3 myDb.db, or do other SQLite command from Android shell, like Terminal Emulator or something else.

I have tried googling for these, but no luck. Is it possible to do that? If it is, how to do it?

I'm using locally-made Android phone in my country, based on Jelly Bean OS.

1
1

Yes, it's possible if you have sqlite3 binary for Android installed. Most of Android devices don't have this binary. If your device doesn't have it, then you need to get the proper binary and install it (refer to Where can I obtain an SQLite 3 command line binary for Android?). Note that you need root access to do this.

After getting the sqlite3 binary, place it inside system/bin/ (or system/xbin/). After this, you just need to test if the terminal can access the binary by calling sqlite3 from there. If it shows sqlite> prompt and SQLite version, then you're done.

For usage hints, on sqlite3, write .help.

sqlite> .help
1
0

You can use Termux for installing sqlite.

Type

$ pkg I sqlite

and there you go on Android.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.