编辑代码

 show databases;
 create database stu
 default character set utf8;
use stu;
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('2022301833','刘同喜', '男','18','MA','蚌埠');
Insert into student (sno,sname,ssex,sage,sdept,saddr) 
values
('2022301824','李源','男','18','MA','铜陵'),
('2022301832','尚宇翔', '男','18','MA','蚌埠'),
('2022301836','徐志强','男','18','MA','芜湖');
select*from student;
select*from student
where sdept='MA';
select*from student
where sage='18';
update student
set sage='17'
where sname='刘同喜';
select*from student;
delete
from student
where sname='刘同喜';
select*from student;
delete
from student;
select*from student;