p79-85

最新推荐文章于 2025-12-03 12:12:23 发布

原创最新推荐文章于 2025-12-03 12:12:23 发布 · 178 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #数据库 #mysql

该文本展示了一系列SQL命令，包括在student1表中创建、插入、查询、更新和删除学生记录，以及使用replaceintotable、setsql_safe_updates和truncatetable等特殊操作。内容涉及学生的学号、姓名、性别、出生日期和成绩等信息。

use stusys;
desc student;
create table student1 like student;
desc student1;
insert into student1
values
('196001','董明霞','女','1999-05-02','通信',50);
select *from student1;
insert into student1 (sno,sname,speciality,tc,ssex,sbirthdat)
values
('196002','李茜','通信','48','女','1998-07-25');
select *from student1;
insert into student1 (sno,sname,sbirthdat,tc)
values
('196004','周俊文','1998-03-10',52);

select *from student;
replace into student1
values
('196002','李茜','女','1998-07-25','通信',48);
create table student2 like student;
insert into student2
select *from student;
select *from student2;

use stusys;
set sql_safe_updates=0;
update student1
set sbirthdat ='1999-03-10'
where sname ='周俊文';
select *from student1;
select *from student;
update student1
set tc = tc+2;
select *from student1;
delete from student1
where sno='196004';
delete from student1;
truncate student;
select *from student;