#【例5.5】对student1表,重新插入记录('196002','李茜','女','1998-07-25','通信’,48)。
use stusys;
create table student1 like student;
select * from student1;
insert into student1
select * from student;
#【例5.6】向student2表插入student表的记录。
use stusys;
create table student2 like student;
select * from student2;
insert into student2
select * from student;
![](https://img-blog.csdnimg.cn/img_convert/b61bac67b1c096cc29af90d69a202c8b.png)
#【例5.7】在student1表中,将学生周俊文的出生日期改为“1999-03-10”。
select * from student1;
SET SQL_SAFE_UPDATES=0;
UPDATE student1
SET sbirthday='1999-03-10'
WHERE sname='周俊文';
![](https://img-blog.csdnimg.cn/img_convert/b8d36b5c99d58a2f6b388e8a76bb1b53.png)
#【例5.8】在student1表中,将所有学生的学分增加2分。
use stusys;
update student1
set tc=tc+2;
select * from student1;
select * from student;
#【例5.9】在student1表中,删除学号为196004的行。
delete from student1
WHERE sno='196004';
#【例5.10】在student1表中,删除所有行。
delete from student1