android sqlite3 在cmd中常用命令详解

1. 启动数据库命令：（sqlite3 *.db）

    adb shell
    cd /data/data/package/databases/
    sqlite3  *.db
   

   eg：

    adb shell
    cd /data/data/com.android.providers.settings/databases
    sqlite3  settings.db
   

2. 显示数据库中所有表名：（.tables）

   sqlite> .tables
   android_metadata   bookmarks          secure
   bluetooth_devices  global             system
   

3. 查询某个表中所有记录：（select * from table_name;）

   sqlite> select * from global;
   1|airplane_mode_on|0
   2|theater_mode_on|0
   3|airplane_mode_radios|cell,bluetooth,wifi,nfc,wimax
   4|airplane_mode_toggleable_radios|bluetooth,wifi,nfc
   5|assisted_gps_enabled|0
   6|auto_time|1
   7|auto_time_zone|1
   8|stay_on_while_plugged_in|0
   9|wifi_sleep_policy|2
   

4. 对应的table可以列出放在对应table中的值

   .dump global
   PRAGMA foreign_keys=OFF;
   BEGIN TRANSACTION;
   CREATE TABLE global (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT UNIQUE ON CONFLICT REPLACE,value TEXT);
   INSERT INTO "global" VALUES(1,'airplane_mode_on','0');
   INSERT INTO "global" VALUES(57,'data_roaming-2','1');
   INSERT INTO "global" VALUES(58,'data_roaming-3','1');
   INSERT INTO "global" VALUES(59,'audio_safe_volume_state','3');
   INSERT INTO "global" VALUES(60,'development_settings_enabled','1');
   INSERT INTO "global" VALUES(65,'adb_enabled','1');
   CREATE INDEX globalIndex1 ON global (name);
   COMMIT;
   

5. (未完)