Android 使用adb shell 查看sqlite数据库

android中的多媒体数据库存放路径如下：

/data/user/0/com.android.providers.media/databases

1.查看是否有设备

E:\ProjectSpace\xxxx>adb devices
List of devices attached
192.168.21.170:5555     device

2.adb shell命令

E:\ProjectSpace\xxxx>adb shell
设备名称:/ # su             //（$只是普通用户，su命令切换到超级用户#）
设备名称:/ # cd data/data

设备名称:/data/data # ls

3.查看Media数据库

设备名称:/data/data # cd com.android.providers.media

设备名称:/data/data/com.android.providers.media # ls
cache code_cache databases files shared_prefs

设备名称:/data/data/com.android.providers.media # cd databases

设备名称:/data/data/com.android.providers.media/databases # ls
external.db     external.db-wal internal.db-shm
external.db-shm internal.db     internal.db-wal

4.查看某个数据库所有表

设备名称:/data/data/com.android.providers.media/databases # sqlite3 external.db
SQLite version 3.19.4 2017-08-18 19:28:12
Enter ".help" for usage hints.

sqlite> .table
album_art              audio_genres           log
album_info             audio_genres_map       search
albums                 audio_genres_map_noid  searchhelpertitle
android_metadata       audio_meta             thumbnails
artist_info            audio_playlists        video
artists                audio_playlists_map    videothumbnails
artists_albums_map     files
audio                  images

sqlite>

5.切换显示模式

sqlite> .mode line

6.查询一些文件(最后记得加；，如果忘记会显示 ...>，解决方法就是敲一个；就可以了)

sqlite> select * from  audio;
 ...> ;

        _id = 155844
          _data = /storage/emulated/0/Download/BootyMusic.mp3
  _display_name = BootyMusic.mp3
          _size = 196584
      mime_type = audio/mpeg
     date_added = 1563523865
         is_drm = 0
  date_modified = 1563523865
          title = BootyMusic
      title_key =     卢
       duration = 12258
      artist_id = 1
       composer =
       album_id = 3
          track = 0
           year =
    is_ringtone = 0
       is_music = 1
       is_alarm = 0
is_notification = 0
     is_podcast = 0
       bookmark =
   album_artist =
    artist_id:1 = 1
     artist_key = ╔
         artist = <unknown>
     album_id:1 = 3
      album_key =        605172610
          album = Download

查询下载的音乐文件
从file下查询

sqlite> select * from files where _data LIKE '/storage/emulated/0/Download/BootyMusic.mp3'
   ...> ;
                _id = 155844
              _data = /storage/emulated/0/Download/BootyMusic.mp3
              _size = 196584
             format = 12297
             parent = 8
         date_added = 1563523865
      date_modified = 1563523865
          mime_type = audio/mpeg
              title = BootyMusic
        description =
      _display_name = BootyMusic.mp3
          picasa_id =
        orientation =
           latitude =
          longitude =
          datetaken =
   mini_thumb_magic =
          bucket_id = 540528482
bucket_display_name = Download
          isprivate =
          title_key =     卢
          artist_id = 1
           album_id = 3
           composer =
              track = 0
               year =
        is_ringtone = 0
           is_music = 1
           is_alarm = 0
    is_notification = 0
         is_podcast = 0
       album_artist =
           duration = 12258
           bookmark =
             artist =
              album =
         resolution =
               tags =
           category =
           language =
    mini_thumb_data =
               name =
         media_type = 2
             old_id =
         storage_id = 65537
             is_drm = 0
              width =
             height =
         

从audio 下查询

sqlite> select * from  audio;
            _id = 155844
          _data = /storage/emulated/0/Download/BootyMusic.mp3
  _display_name = BootyMusic.mp3
          _size = 196584
      mime_type = audio/mpeg
     date_added = 1563523865
         is_drm = 0
  date_modified = 1563523865
          title = BootyMusic
      title_key =     卢
       duration = 12258
      artist_id = 1
       composer =
       album_id = 3
          track = 0
           year =
    is_ringtone = 0
       is_music = 1
       is_alarm = 0
is_notification = 0
     is_podcast = 0
       bookmark =
   album_artist =
    artist_id:1 = 1
     artist_key = ╔
         artist = <unknown>
     album_id:1 = 3
      album_key =        605172610
          album = Download

7.查看表结构

sqlite> pragma table_info(images);
pragma table_info(images);
0|_id|INTEGER|0||0
1|_data|TEXT|0||0
2|_size|INTEGER|0||0
3|_display_name|TEXT|0||0
4|mime_type|TEXT|0||0
5|title|TEXT|0||0
6|date_added|INTEGER|0||0
7|date_modified|INTEGER|0||0
8|description|TEXT|0||0
9|picasa_id|TEXT|0||0
10|isprivate|INTEGER|0||0
11|latitude|DOUBLE|0||0
12|longitude|DOUBLE|0||0
13|datetaken|INTEGER|0||0
14|orientation|INTEGER|0||0
15|mini_thumb_magic|INTEGER|0||0
16|bucket_id|TEXT|0||0
17|bucket_display_name|TEXT|0||0
18|width|INTEGER|0||0
19|height|INTEGER|0||0
20|is_favorite|INTEGER|0||0
21|date_favorited|LONG|0||0
22|datetaken_favorited|LONG|0||0
23|creator_package|TEXT|0||0

8 退出sqlite
一般是进入SQL数据语言模式了，此时要想退出...>状态，只要输入一条完整的SQL语句就行了，也就是末尾要加上；或者直接输入；（分号）这个符号，就可以退回到sqlite>状态

...> ;
Error: near "sqlite": syntax error
sqlite> 

那退出sqlite 回到shell下，不要忘了"点".

sqlite> .quit

9.想要由shell状态进入普通的命令行状态，输入exit即可

设备名称:/ # exit

参考来源：
https://www.cnblogs.com/nicoleTeng/p/9023167.html
还有一种是插件Database Navigator查看sqlite数据库
https://blog.csdn.net/pshiping2014/article/details/82585516