Android使用命令列操作資料庫

標籤：sqlite資料庫   使用   esc   sele   desc   enter   odi   user   package   

所有的應用程式本地檔案都存放在/data/data/目錄下

C:\Users\nicole>adb shell* daemon not running. starting it now on port 5039 ** daemon started successfully *N555J:/ $ su    （$只是普通使用者，su命令切換到超級使用者#）N555J:/ # cd data/dataN555J:/data/data # ls

查看Media資料庫

N555J:/data/data # cd com.android.providers.mediaN555J:/data/data/com.android.providers.media # lscache code_cache databases files shared_prefs
N555J:/data/data/com.android.providers.media # cd databasesN555J:/data/data/com.android.providers.media/databases # lsexternal.db     external.db-wal internal.db-shmexternal.db-shm internal.db     internal.db-wal

查看某個資料庫所有表

N555J:/data/data/com.android.providers.media/databases # sqlite3 external.dbSQLite version 3.19.4 2017-08-18 19:28:12Enter ".help" for usage hints.sqlite> .tablealbum_art              audio_genres           logalbum_info             audio_genres_map       searchalbums                 audio_genres_map_noid  searchhelpertitleandroid_metadata       audio_meta             thumbnailsartist_info            audio_playlists        videoartists                audio_playlists_map    videothumbnailsartists_albums_map     filesaudio                  imagessqlite>

查看錶結構

sqlite> pragma table_info(images);pragma table_info(images);0|_id|INTEGER|0||01|_data|TEXT|0||02|_size|INTEGER|0||03|_display_name|TEXT|0||04|mime_type|TEXT|0||05|title|TEXT|0||06|date_added|INTEGER|0||07|date_modified|INTEGER|0||08|description|TEXT|0||09|picasa_id|TEXT|0||010|isprivate|INTEGER|0||011|latitude|DOUBLE|0||012|longitude|DOUBLE|0||013|datetaken|INTEGER|0||014|orientation|INTEGER|0||015|mini_thumb_magic|INTEGER|0||016|bucket_id|TEXT|0||017|bucket_display_name|TEXT|0||018|width|INTEGER|0||019|height|INTEGER|0||020|is_favorite|INTEGER|0||021|date_favorited|LONG|0||022|datetaken_favorited|LONG|0||023|creator_package|TEXT|0||0

切換顯示模式

sqlite> .mode linesqlite> pragma table_info(images);pragma table_info(images);       cid = 0      name = _id      type = INTEGER   notnull = 0dflt_value =        pk = 0       cid = 1      name = _data      type = TEXT   notnull = 0dflt_value =        pk = 0       cid = 2      name = _size      type = INTEGER   notnull = 0dflt_value =        pk = 0

查詢表中的資料

sqlite> select * from images;                _id = 1              _data = /storage/emulated/0/Pictures/Screenshots/Screenshot_2018-05-10-10-27-04.png              _size = 1987030      _display_name = Screenshot_2018-05-10-10-27-04.png          mime_type = image/png              title = Screenshot_2018-05-10-10-27-04.png         date_added = 1525919227      date_modified = 1525919227        description =          picasa_id =          isprivate =           latitude =          longitude =          datetaken = 1525919224704        orientation =   mini_thumb_magic =          bucket_id = 1028075469bucket_display_name = Screenshots              width = 1080             height = 2160        is_favorite = 0     date_favorited = 1525919227datetaken_favorited = 1525919227098    creator_package =

查看資料庫所有表的建表語句(每個SQLite資料庫中都還有一個隱藏的sqlite_master表)

sqlite> select * from sqlite_master;    type = table    name = android_metadatatbl_name = android_metadatarootpage = 3     sql = CREATE TABLE android_metadata (locale TEXT)    type = table    name = thumbnailstbl_name = thumbnailsrootpage = 6     sql = CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER,kind INTEGER,width INTEGER,height INTEGER)    type = index    name = image_id_indextbl_name = thumbnailsrootpage = 7     sql = CREATE INDEX image_id_index on thumbnails(image_id)    type = table    name = artiststbl_name = artistsrootpage = 10     sql = CREATE TABLE artists (artist_id INTEGER PRIMARY KEY,artist_key TEXT NOT NULL UNIQUE,artist TEXT NOT NULL)

 

Android使用命令列操作資料庫