sqlite3位置
android-sdk-windows\platform-tools
創(chuàng)建數(shù)據(jù)庫(kù)
sqlite3.exe test.db
這時(shí)在platform-tools文件中看不到test.db數(shù)據(jù)庫(kù)，關(guān)閉數(shù)據(jù)庫(kù)才能看到
.quit
創(chuàng)建數(shù)據(jù)表
create table log(id,value);
插入數(shù)據(jù)
insert into log values(1,'u');
修改數(shù)據(jù)
update log set value='d' where id=1;
刪除數(shù)據(jù)
delete from log where id=1;
刪除數(shù)據(jù)表
drop table log;
