admin 管理员组

文章数量: 893893

p79

 

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;

本文标签： p79

版权声明：本文标题：p79 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.freenas.com.cn/jishu/1687328733h90132.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。