p79-85

ALhq1008

于 2023-03-29 21:04:11 发布

阅读量164

点赞数 1

CC 4.0 BY-SA版权

文章标签： sql 数据库 mysql

本文链接：https://blog.youkuaiyun.com/ALhq1008/article/details/129845538

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;