3：增，删，改数据

1：新增所有字段数据

insert into student values(10,'ss',10,'aa','162354587'),(11,'ss',1,'am','162354597');

2：为部分字段添加数据

insert into student(name,age,address,iphone) values ('ss',10,'aa','162354585');

insert into student(name,age,address,iphone) values ('ss',10,'aa','182354585'),('sw',10,'ap','162354589');

3：修改--不加where条件是修改表对应字段的全部数据

全部

update student set address='bb'

指定

update student set address='bb',iphone='2356' where id =2;

update student set address=' ' where id =2;

4：删除指定数据

delete from student where id =3;

删除全部数据（清空表）

delete from student