Sqlite数据库 基本命令

以 /data/user_de/0/com.android.providers.telephony/databases 下的telephony.db为例说明

1，查看该db下所有表
sqlite>.tables

注意，命令此命令后面不要添加 ;

2，查看表结构
sqlite> .schema siminfo

整理处理该表的字段如下：
_id
icc_id
sim_id
display_name
carrier_name
name_source
color number
display_number_format
data_roaming
mcc
mnc
sim_provisioning_status
is_embedded
card_id
access_rules
is_removable
enable_cmas_extreme_threat_alerts
enable_cmas_severe_threat_alerts
enable_cmas_amber_alerts
enable_emergency_alerts
alert_sound_duration
alert_reminder_interval
enable_alert_vibrate
enable_alert_speech
enable_etws_test_alerts
enable_channel_50_alerts
enable_cmas_test_alerts
show_cmas_opt_out_dialog
enable_noncellbroadcast
use_full_volume
volte_vt_enabled
vt_ims_enabled
wfc_ims_enabled
wfc_ims_mode
wfc_ims_roaming_mode
wfc_ims_roaming_enabled
sqlite> select * from siminfo;

3，查找表的所有数据
sqlite> select * from siminfo;
注意此命令后面要添加 ;

4，删除某条记录