MYSQL 查询练习①

一、创建表格

①学生表（Student）

学号	姓名	性别	出生年月日	所在班级

Create table student(
	Sno varchar(20) primary key,
	Sname varchar(20) not null,
	Ssex varchar(10) not null,
	Sbirthday datetime,
	Class varchar(20)
);

–向学生表中添加数据

Insert into student values('108','曾华','男','1997-09-01','95033');
Insert into student values('107','王丽','女','1997-09-01','95031');
Insert into student values('101','曾华','男','1997-09-01','95033');
Insert into student values('103','李俊','男','1997-09-01','95033');
Insert into student values('104','王芳','女','1997-09-01','95033');
Insert into student values('109','陆君','