Android virtual machine adb shell Sqlite3 database

ADB Shell Connection:

http://www.cnblogs.com/xiaobo-Linux/

Android Stores the data in the data/data directory.

We use the CD command to go to the data/data directory:

Cd/data/data

ls command you will see studdb.db, This is our studdb.db database.

  

Sqlite3 studdb.db

This command opens the studdb.db database, and if the studdb.db database does not exist, a new one is created that is named

The studdb.db database. ( Note that database name is different in case )

At the sqlite> prompt, enter

. Help this command lets us see a lot of commands

. Tables View all tables, for example, my system has Student and android_metadata two tables

SELECT * from Student;

We found three data. The way the database is displayed lets us get used to the Oralce, which is very uncomfortable, input

The following two commands let us change this display mode.

. Mode column

. Header on

re-enter select * from Student ; We look more comfortable.

 

The . Exit command exits SQLiteand returns to the # prompt.

Enter exit at the # prompt to exit Linux.

Android virtual machine adb shell Sqlite3 database