Android database query record __ Database

root@android:/# CD data/data/
cn.amazon.mshop.android/com.android.providers.downloads/
cn.com.sina.newshd/com.android.providers.drm/
com.amlogic.oobe/com.android.providers.media/
com.amlogic.inputmethod.remote/com.android.providers.settings/
com.amlogic.mediacenter/com.android.providers.telephony/
com.android.backupconfirm/com.android.providers.userdictionary/
com.android.browser/com.android.provision/
com.android.calculator2/com.android.quicksearchbox/
com.android.calendar/com.android.settings/
com.android.certinstaller/com.android.sharedstoragebackup/
com.android.contacts/com.android.smspush/
com.android.defcontainer/com.android.soundrecorder/
com.android.deskclock/com.android.systemui/
com.android.development/com.android.vpndialogs/
com.android.email/com.android.wallpaper.holospiral/
com.android.exchange/com.android.wallpaper.livepicker/
com.android.filemanagertest/com.android.wallpaper/
com.android.galaxy4/com.baidu.input/
com.android.gallery3d/com.dehoo.iptv/
com.android.htmlviewer/com.estrongs.android.pop/
com.android.inputdevices/com.farcore.videoplayer/
Com.android.inputmethod.latin/com.guozi.appstore/
com.android.inputmethod.pinyin/com.hiapk.markettv/
Com.android.keychain/com.hycstv.android/
com.android.launcher/com.jingdong.app.tv/
com.android.magicsmoke/com.nd.android.pandareader/
com.android.music/com.philips.ecd/
com.android.musicfx/com.philips.ggc.sp/
com.android.musicvis/com.philips.setupwizard/
com.android.noisefield/com.philips.sound/
com.android.packageinstaller/com.philips.updater/
com.android.phasebeam/com.qipo/
com.android.phone/com.sina.weibo/
com.android.providers.applications/com.svox.pico/
com.android.providers.calendar/com.voole.epg/
com.android.providers.contacts/com.voole.vooledesktop/
com.android.providers.downloads.ui/jp.co.omronsoft.openwnn/
a/com.android.providers.media/<
Root@android:/data/data/com.android.providers.media # ls
Cache
Databases
Lib
Shared_prefs
D databases/<
Root@android:/data/data/com.android.providers.media/databases # ls
External.db
External.db-shm
External.db-wal
Internal.db
Internal.db-shm
Internal.db-wal
Root@android:/data/data/com.android.providers.media/databases # Sqlite3
130|root@android:/data/data/com.android.providers.media/databases #
127|root@android:/data/data/com.android.providers.media/databases # ls
External.db
External.db-shm
External.db-wal
Internal.db
Internal.db-shm
Internal.db-wal
Rnal.db <
SQLite version 3.7.11 2012-03-20 11:35:50
Enter '. Help ' for instructions
Enter SQL statements terminated with a ";"
Sqlite>
Sqlite>
Sqlite>. Tables
Album_art Audio_playlists_map
Album_info Available_files
Albums Available_thumbnails
Android_metadata available_videothumbnails
Artist_info Ext_volumes
Artists files
Artists_albums_map Images
Audio log
Audio_genres Search
Audio_genres_map Searchhelpertitle
Audio_genres_map_noid thumbnails
Audio_meta Video
Audio_playlists videothumbnails
Sqlite>. Header on
sqlite>. Mode Line
Sqlite> select * FROM video;

Sqlite>. Exit