Android SQLite 数据库增删改查dos命令行语句

---

2.删

---

删除数据库中的所有数据：delete from 表名

delete from student_score

3.改

---

![](https://img-blog.csdn.net/20170210221504028?watermark/2/tex
t/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvZ2l0aHViXzIwMTE=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)

4.查

---

命令代码如下：

//增加

insert into student_score values (1,“马云”,100);

insert into student_score values (2,“马化腾”,100);

insert into student_score values (3,“王健林”,100);

insert into student_score values (4,“汪涛”,100);

insert into student_score values (null,“程序员”,101);

//删除

delete from student_score where name = “马化腾”;

delete from student_score where score = 101;

delete from student_score where _id = 3;

delete from student_score;