- sqlite3 contacts2.db; 打开数据库文件
- .table list 数据库中的表
- schema calls; 列出指定名称表的所有字段
- insert into calls (‘number’,’name’) VALUES (’13770525123′,’police’); 插入数据
- delete from calls where _id =1;
- select * from calls where _id>1 order by _id asc limit 5 offset 3;
- update calls set name=’police’ where _id=+2;
- create table callc
- drop table callc
- .exit
sqlite3
最新推荐文章于 2024-08-03 11:10:23 发布