How to create student table using sql statement

The code to use SQL statements to create the student table in the database is as follows:

 
(  
学号 char(12) primary key,  
姓名 char(6) not null,  
性别 char(2) check(性别 IN ('男','女')),  
班级 char(15)  
)

Creation of related tables:

create table 成绩表  
(  
学号 char(12)references 学生表(学号),  
课程号 char(2)references 课程表(课程号),  
成绩 int default(30),  
primary key (学号,课程号)  
)  
create table 课程表  
(  
课程号 char(2) primary key,  
课程名 char(20),  
学分 int check(学分>=1 and 学分<=5 )  
)

Related operations:

insert into 学生表 values('201190609112','张xl','男','文专计1111')  
insert into 学生表 values('201190609113','张**','女','文专计1111')  
insert into 成绩表 values('201190609112','01',100)  
insert into 成绩表 values('201190609112','02',99)  
insert into 成绩表 values('201190609112','03',88)  
insert into 课程表 values('01','数据库系统',3)  
insert into 课程表 values('02','vb.net',4)  
insert into 课程表 values('03','java',4)  
select *from 成绩表  
select 姓名,课程名,成绩   
from 学生表,课程表,成绩表   
where (学生表.学号=成绩表.学号 and 课程表.课程号=成绩表.课程号)  
order by 成绩 desc  
select avg(成绩) 平均分,max(成绩) 最高分,min(成绩) 最低分  
from 成绩表  
where 学号='201190609112

For more MySQL related technical articles, please visit the MySQL Tutorial column to learn!

The above is the detailed content of How to create student table using sql statement. For more information, please follow other related articles on the PHP Chinese website!