编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
sno char(10)  primary key,
sname char(20) unique,
ssex char(2),
sage smallint,
sdept char(40),
saddr char(100)
);
insert into student(sno,sname,ssex,sage,sdept,saddr)
values
('3081','一号','男',18,'AQ','仁苑A432'),
('3082','二号','男',18,'AQ','仁苑A432'),
('3083','三号','男',18,'AQ','仁苑A432'),
('3084','四号','女',18,'AQ','仁苑A432');
select * from student;
select sno from student;
select sname from student;
select * from student where ssex='女';
select * from student where sname='一号';
update student set ssex='男' where sname='四号';
select * from student ;
insert into student values('3085','五号','女',18,'AQ','淮南');
select * from student;
delete from student where ssex='女';
select * from student;