【android】[SQlite] common commands explanations

adb shell

cd data/data/xxx

cd databases

sqlite3 xx.db

sqlite>.tables

sqlite>select * from xx;

sqlite>delete from system where name like "aaa%"

sqlite>delete from system where _id= 138;;

sqlite>delete from system where name = '';

sqlite>.exit