#【例5.1】向student1表插入一条记录('196001','董明霞','女','1999-05-02','通信’,50)。
insert into student1
values('196001','董明霞','女','1999-05-02','通信','50');
select * from student1;
#【例5.2】向student1表插入一条记录,学号为“196002”,姓名为“李茜”,专业为“通信”,总学分48,性别为“女”,出生日期为“1998-07-25”。
insert into student1(sno,sname,speciality,tc,ssex,sbirthday)
values('196002','李茜','通信','48','女','1998-07-25');
select * from student1;
#【例5.3】向student1表插入一条记录,学号为“196004”,姓名为“周俊文”,性别为“男”、取默认值,出生日期为“1998-03-10”,专业为空值,总学分为52。
insert into student1(sno,sname,sbirthday,tc)
values('196004','周俊文','1998-03-10','52');
select * from student1;
#【例5.4】向student表插入样本数据,共6条记录,参见附录B。
insert into student1
values('191001','刘清泉','男','1998-06-21','计算机','52'),
('191002','张慧玲','女','1999-11-07','计算机','50'),
('191003','冯涛','男','1999-08-12','计算机','52'),
('196001','董明霞','女','1999-05-02','通信','50'),
('196002','李茜','女','1998-07-25','通信','48'),
('196004','周俊文','男','1998-03-10','通信','52');
#【例5.5】对student1表,插入表student全部数据。
use stusys;
create table student1 like student;
insert into student1
select * from student;
#【例5.6】向student2表插入student表的记录。
use stusys;
create table student2 like student;
insert into student2
select * from student;
#【例5.7】在student1表中,将学生周俊文的出生日期改为“1999-03-10”。
select * from student1;
SET SQL_SAFE_UPDATES=0;
UPDATE student1
SET sbirthday='1999-03-03'
WHERE sname='周俊文';
#【例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';
select * from student1;
#【例5.10】在student1表中,删除所有行。
delete from student1;
select * from student1;
#【例5.11】在student表中,删除所有行。
truncate student;
select * from student1;