ADB shell view database in emulator (3.8.6 previous version does not support recursive queries)

I'm going to look at the database in Eclipse and operate it through CMD. Directory path is:/data/data/com.abc.oa

It is more convenient to use the SqLite3 command directly in the ADB shell.

1. Open cmd

2. Direct input to adb shell

3. Enter cd/data/data/com.sinping.oa/databases carriage return (Enter the database folder)

4. Input LS (list all database files. db)

5. Input Sqlite3 sinpingoa.db

6. You can write the SQL statement at this time (remember the end of the statement plus;)

7. The following two commands are used to display data with headers and columns:

With. Mode column

With. Header on

8. At the sqlite> prompt, enter
. Help this command lets us see many commands
. Tables View all tables, such as student and android_metadata two tables in my system

. Quit Exit Sqlite3

. CLS Clear screen (not available in sqlite3)

Exit to C and then use Exit