tasker吧 关注：12,876贴子：28,512
- 8回复贴，共1页
③sqlite> .tables
输出该数据的所有表的名：
_sync_state phone_lookup view_data_usage_stat
_sync_state_metadata photo_files view_entities
accounts properties view_groups
agg_exceptions raw_contacts view_raw_contacts
android_metadata search_index view_raw_entities
calls search_index_content view_stream_items
contacts search_index_docsize view_v1_contact_methods
data search_index_segdir view_v1_extensions
data_usage_stat search_index_segments view_v1_group_membership
default_directory search_index_stat view_v1_groups
deleted_contacts settings view_v1_organizations
directories status_updates view_v1_people
groups stream_item_photos view_v1_phones
mimetypes stream_items view_v1_photos
name_lookup v1_settings visible_contacts
nickname_lookup view_contacts voicemail_status
packages view_data
注：可以看到这里有非常多表，具体哪个表什么用，百度是最好的；data 就是联系人的表，calls 是通话记录
进一步，可以查询表 sqlite_master，里面的信息更详细
sqlite>select * from sqlite_master;
type|name|tbl_name|rootpage|sql
table|android_metadata|android_metadata|3|CREATE TABLE android_metadata (locale TEXT)
table|_sync_state|_sync_state|4|CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account_name, account_type))index|sqlite_autoindex__sync_state_1|_sync_state|5|
table|_sync_state_metadata|_sync_state_metadata|6|CREATE TABLE _sync_state_metadata (version INTEGER)
................
注：第一行就是表头，可以看到 name 就是表名
输出该数据的所有表的名：
_sync_state phone_lookup view_data_usage_stat
_sync_state_metadata photo_files view_entities
accounts properties view_groups
agg_exceptions raw_contacts view_raw_contacts
android_metadata search_index view_raw_entities
calls search_index_content view_stream_items
contacts search_index_docsize view_v1_contact_methods
data search_index_segdir view_v1_extensions
data_usage_stat search_index_segments view_v1_group_membership
default_directory search_index_stat view_v1_groups
deleted_contacts settings view_v1_organizations
directories status_updates view_v1_people
groups stream_item_photos view_v1_phones
mimetypes stream_items view_v1_photos
name_lookup v1_settings visible_contacts
nickname_lookup view_contacts voicemail_status
packages view_data
注：可以看到这里有非常多表，具体哪个表什么用，百度是最好的；data 就是联系人的表，calls 是通话记录
进一步，可以查询表 sqlite_master，里面的信息更详细
sqlite>select * from sqlite_master;
type|name|tbl_name|rootpage|sql
table|android_metadata|android_metadata|3|CREATE TABLE android_metadata (locale TEXT)
table|_sync_state|_sync_state|4|CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account_name, account_type))index|sqlite_autoindex__sync_state_1|_sync_state|5|
table|_sync_state_metadata|_sync_state_metadata|6|CREATE TABLE _sync_state_metadata (version INTEGER)
................
注：第一行就是表头，可以看到 name 就是表名
