实验楼 mysql_挑战：搭建一个简易的成绩管理系统的数据库

show databases;

mysql> create database gradesystem;

mysql> use gradesystem;

mysql> create table student (id int(11) primary key auto_increment, sname varchar(20), gender enum('male','female') default 'male');

mysql> create table course(id int(11) primary key auto_increment, cname varchar(20));

mysql> create table mark ( mid int(11) primary key auto_increment, sid int(11) , cid int(11) , score int(11));

mysql> insert into student(sname, gender) values('Tom', 'male'),

-> ('Jack', 'male'),

-> ('Rose', 'female');

mysql> insert into course (cname) values('math'),

-> ('physics'),

-> ('chemistry');

mysql> insert into mark (sid, cid, score) values(1, 1, 80),

-> (2, 1, 85),

-> (3, 1, 90),

-> (1, 2, 60),

-> (2, 2, 90),

-> (3, 2, 75),

-> (1, 3, 95),

-> (2, 3, 75),

-> (3, 3, 85);