Connect to a database:
adb shell
# sqlite3 contacts.db
end sqlite3 command shell
# .exit
List tables:
.table
Print some of the information from the tables:
.header on
.mode column
Query
sqlite> select * from phones;
to drop table:
sqlite> drop table tablename
More in here: http://www.sqlite.org/sqlite.html
to drop table:
sqlite> drop table tablename
More in here: http://www.sqlite.org/sqlite.html
沒有留言:
張貼留言