编辑代码

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','一号','男',17,'AQ','仁苑A432'),
('3082','二号','男',18,'AQ','仁苑A432'),
('3083','三号','男',19,'AQ','仁苑A432'),
('3084','四号','男',18,'AQ','仁苑A432');
select * from student where sname='一号';
select * from student;
select * from student where sage='18';
update student set sage='17' where sname='四号';
select * from student;