android qlite3命令查看数据库
学习android ,初学，最影响最深的就是活动了，active 了。现在有数据库了，那是一个激动，但是查看SQLite 数据库用命令还是特别不习惯，就要还是一个 SU 命令。在此备份，分享快乐
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\yy06>cd C:\Program Files (x86)\Android\android-sdk\platform-tools
C:\Program Files (x86)\Android\android-sdk\platform-tools>adb shell
generic_x86:/ $ su
generic_x86:/ # cd data
generic_x86:/data # cd data
generic_x86:/data/data # ls
android
com.android.backupconfirm
com.android.bookmarkprovider
com.android.calculator2
com.android.camera
com.android.captiveportallogin
com.android.carrierconfig
com.android.cellbroadcastreceiver
com.android.certinstaller
com.android.chrome
com.android.contacts
com.android.cts.ctsshim
com.android.cts.priv.ctsshim
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.dialer
com.android.documentsui
com.android.dreams.basic
com.android.egg
com.android.emergency
com.android.emulator.smoketests
com.android.externalstorage
com.android.fallback
com.android.gallery3d
com.android.gesture.builder
com.android.htmlviewer
com.android.inputdevices
com.android.inputmethod.latin
com.android.keychain
com.android.location.fused
com.android.managedprovisioning
com.android.mms.service
com.android.mtp
com.android.netspeed
com.android.pacprocessor
com.android.phone
com.android.printspooler
com.android.protips
com.android.providers.blockednumber
com.android.providers.calendar
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.media
com.android.providers.partnerbookmarks
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.proxyhandler
com.android.sdksetup
com.android.server.telecom
com.android.settings
com.android.sharedstoragebackup
com.android.shell
com.android.smoketest
com.android.smoketest.tests
com.android.statementservice
com.android.storagemanager
com.android.systemui
com.android.vending
com.android.vpndialogs
com.android.wallpaper.livepicker
com.android.wallpaperbackup
com.android.widgetpreview
com.breel.geswallpapers
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.google.android.apps.docs
com.google.android.apps.maps
com.google.android.apps.messaging
com.google.android.apps.nexuslauncher
com.google.android.apps.photos
com.google.android.apps.wallpaper
com.google.android.apps.wallpaper.nexus
com.google.android.backuptransport
com.google.android.calendar
com.google.android.configupdater
com.google.android.ext.services
com.google.android.ext.shared
com.google.android.feedback
com.google.android.gm
com.google.android.gms
com.google.android.googlequicksearchbox
com.google.android.gsf
com.google.android.gsf.login
com.google.android.music
com.google.android.nexusicons
com.google.android.onetimeinitializer
com.google.android.packageinstaller
com.google.android.partnersetup
com.google.android.printservice.recommendation
com.google.android.setupwizard
com.google.android.syncadapters.contacts
com.google.android.talk
com.google.android.tts
com.google.android.videos
com.google.android.webview
com.google.android.youtube
com.ustwo.lwp
jp.co.omronsoft.openwnn
org.chromium.webview_shell
yanming.com.databasetest
generic_x86:/data/data # cd yanming.com.databasetest
generic_x86:/data/data/yanming.com.databasetest # cd databases
generic_x86:/data/data/yanming.com.databasetest/databases # ls
BookStore2.db BookStore2.db-journal bookstore2.db
qlite3 BookStore2.db; <
SQLite version 3.9.2 2015-11-02 18:31:45
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE Book(id integer primary key autoincrement,author text,price real,pa
ges integername text);
sqlite> .scheman
Error: unknown command or invalid arguments: "scheman". Enter ".help" for help
sqlite> .schema
CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE Book(id integer primary key autoincrement,author text,price real,pa
ges integername text);
sqlite>