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
('307144','王嘉硕','男',18,'KC','信苑B121'),
('308888','曹鹏飞','男',18,'KC','信苑B121'),
('307199','周添乐','男',18,'KC','信苑B121'),
('307145','李浩然','女',18,'KC','信苑B121');
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('2022306666','张梦圆','女',18,'JY','保定顺平');
select * from student;
delete from student where ssex='女';
select * from student;