Android - adb devices

$ adb devices List of devices attached emulator-5554 device --> print device list

$ adb devices
List of devices attached
emulator-5554   device
--> print device list

 

$ adb -s emulator-5554 shell
# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db
SQLite version 3.3.12
Enter ".help" for instructions
.... enter commands, then quit...
sqlite> .exit 

Once you've invoked sqlite3, you can issue sqlite3 commands in the shell. To exit and return to the adb remote shell, use exit or CTRL+D. 


/data/data/com.android.providers.contacts/databases
# sqlite3 contacts2.db
sqlite3 contacts2.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
.table
_sync_state                       settings
_sync_state_metadata              status_updates
accounts                          v1_settings
activities                        view_contacts
agg_exceptions                    view_contacts_restricted
android_metadata                  view_data
calls                             view_data_restricted
contact_entities_view             view_groups
contact_entities_view_restricted  view_raw_contacts
contacts                          view_raw_contacts_restricted
data                              view_v1_contact_methods
groups                            view_v1_extensions
mimetypes                         view_v1_group_membership
name_lookup                       view_v1_groups
nickname_lookup                   view_v1_organizations
packages                          view_v1_people
phone_lookup                      view_v1_phones
properties                        view_v1_photos

sqlite> .header on
.header on
sqlite> .mode column
.mode column
sqlite> select * from mimetypes;
select * from mimetypes;
_id         mimetype
----------  --------------------------------
1           vnd.android.cursor.item/email_v2
2           vnd.android.cursor.item/im
3           vnd.android.cursor.item/postal-a
4           vnd.android.cursor.item/photo
5           vnd.android.cursor.item/phone_v2
6           vnd.android.cursor.item/name
7           vnd.android.cursor.item/organiza
8           vnd.android.cursor.item/nickname
9           vnd.android.cursor.item/group_me