?

G:\Users\Window7>adb shell
#

?

# sqlite3 /data/data/com.example.android.notepad/databases/note_pad.db

sqlite3 /data/data/com.example.android.notepad/databases/note_pad.db

SQLite version 3.6.22

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite>

?

sqlite> .help

.help

.backup ?DB? FILE????? Backup DB (default "main") to FILE

.bail ON|OFF?????????? Stop after hitting an error.? Default OFF

.databases???????????? List names and files of attached databases

.dump ?TABLE? ...????? Dump the database in an SQL text format

???????????????????????? If TABLE specified, only dump tables matching

???????????????????????? LIKE pattern TABLE.

.echo ON|OFF?????????? Turn command echo on or off

.exit????????????????? Exit this program

.explain ?ON|OFF?????? Turn output mode suitable for EXPLAIN on or off.

???????????????????????? With no args, it turns EXPLAIN on.

.genfkey ?OPTIONS????? Options are:

???????????????????????? --no-drop: Do not drop old fkey triggers.

???????????????????????? --ignore-errors: Ignore tables with fkey errors

???????????????????????? --exec: Execute generated SQL immediately

?????????????????????? See file tool/genfkey.README in the source

?????????????????????? distribution for further information.

.header(s) ON|OFF????? Turn display of headers on or off

.help????????????????? Show this message

.import FILE TABLE???? Import data from FILE into TABLE

.indices ?TABLE??????? Show names of all indices

???????????????????????? If TABLE specified, only show indices for tables

???????????????????????? matching LIKE pattern TABLE.

.load FILE ?ENTRY????? Load an extension library

.log FILE|off????????? Turn logging on or off.? FILE can be stderr/stdout

.mode MODE ?TABLE????? Set output mode where MODE is one of:

???????????????????????? csv????? Comma