用插件sqlite3
2、 sqlite 1. 把未读消息更新为已读
sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db; update sms set read='1' where read='0';
.exit 2. 删除联通发来的未读短信
sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db; delete from sms where read='0' and address='10010';
.exit
3. 查看短信内容里含有发票的短信 sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db; select body from sms where body like '%发票%';
.exit
4. 删除最新的一条短信
sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db; delete from sms where _id=(select _id from sms order by _id desc limit 1); .exit
5. 来电地址
SELECT location FROM LocationInfo WHERE _id=( SELECT location FROM CallerLoc WHERE number=’%Gbbb1’; 6. 获取某个号码的所有短信
SELECT body FROM sms WHERE address LIKE('%10086%') LIMIT 1;