3、数据操作语言DML

1、插入操作

select *from student where id =1;

insert into student(id,stu_name,stu_age) value(3,'刘备',20);

insert into student(id,stu_name,stu_age) value(3,'刘备',20),(4,'张飞',21),(5,'关羽',22);

insert into student value(6,'关羽',22);

2、更新操作

alter table student add stu_score float;

update student set stu_score=90;

update student set stu_score=60 where stu_name='张三';

update student set stu_age=20 ,stu_score=70 where stu_name='李四';

update student set stu_age=stu_age+1 where stu_name='李四';

3、修改数据库密码

修改完密码后，要进行接下来的操作：

4、删除操作

delete from student where id=6;

// 删除表student中所有的数据
delete from student;

// 删除表student中所有的数据
truncat table student;