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

  • 0
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

葫芦娃你好我是皮卡丘

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值