show databases;
create database test
default character set utf8;
show databases;

use test;

create table student(
    sno char(100) primary key,
    sname char(20)unique,
    ssex char(2),
    sage smallint,
    sdept char(40),
    sadder char(100)
);


select*from student;

insert into student values
('2022302144','田华宇','男',18,'IM'),
('2022302145','李阚宇','男',18,'IM')，
('2022302163','王梓坤','男',18,'IM')，

select*from student;

select sno,sname,ssex,sage,sdept
from student;